Aggregate of Group Aggregate

  • Thread starter Thread starter Fred
  • Start date Start date
F

Fred

Is there any way to perform an aggregate function in a report on the results
of a group aggregate function?

For example, if one had lists of transactions, , grouped them by day, and
created daily totals [=sum()] in the group-by-day footer. Now, to
calculate calculate the average of the daily totals?

This is different the the usual issue of not being able to recycle the
answer of a calculation......where you just retype the original calculation
and nest it in the second one.


Thanks in advance for any help!
 
I suspect you could use the Sum() like in the day group footer but then
divide by the number of day sections/groups. To count the number of day
groups, you would add a text box to the group footer:
Name: txtCountDays
Control Source: =1
Running Sum: Over Group
Visible: No
Then in the larger group footer, you could get the average with a control
source of:
Control Source: =Sum(...)/txtCountDays
 
Back
Top