Aggregate of Group Aggregate

[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!

 

[Duane Hookom]

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

 

[Fred]

Thanks Duane, it worked great.