Skip to Content
0
Former Member
Feb 14, 2011 at 01:04 PM

CrossTab averaging % statistics

27 Views

Hello,

I have created a cross tab report using statistics, some of which are formulas.

The report itself is sorted by day of week statistic and query covers the existing month.

However the problem starts when one of the the formula statistics (=Answered/Entered) is not calculated correctly for each day, but rather averaging each days individual figures. For example if there are 4 mondays in the month, with figures of 80/84/83/82, the row for Monday averages all of those rather than take the total answered and divide that by total entered.

The answered and entered figures themselves are a sum of so are correct but the efficiency is an average.

Any ideas?

Thanks,

WA