If you are unable to create a new account, please email support@bspsoftware.com

 

Summary Row in list report aggregating totals instead of using calculation

Started by Scott Stone, 27 Feb 2007 10:58:42 AM

Previous topic - Next topic

Scott Stone

Hello,

I have a list report that is supposed to display average days and amounts paid by user. The users are grouped so that for each user it shows the counts and each user has a summary row Avg Days & Amounts which is a data item, which is working correctly.

However at the bottom of the report I have a summary for all of the users, which is supposed to re-calculate the overall average, which also has a the same calculation from another query that is not grouped on the user. Otherwise the calculations for the days/counts are the same. The problem is that instead of pulling the day counts and doing the calculation it appears to be simply ignoring the calculation and just totaling the avarages from the user summary lines above.

I have tried changing the class of the row, messing with the aggregation settings etc.. all to no avail. Any help would be greatly appreciated.


bdybldr

Have you tried creating a calculation in your tabular model to calculate the overall average?

It should resemble this:
TOTAL([Amounts] for report) / TOTAL([Days]) for report).

Cut the default aggregate from the report and insert this data item in its place.

HTH.