HI,
I am trying to publish average by month.
So each month is specified as jan 2012, feb 2012 etc. I am trying to retrieve from "date of audit" and "percentage" columns.
the result must be AVERAGE OF THE AUDITS WHICH FALLS UNDER SPECIFIC MONTHS.
Example if january 2012 has 12 audits and their average percentage was 83.20 %.
Would be able to report month wise. Please advise the expression / formula for a report !
Regards