I have a report that provides storage volume data for products in a warehouse. At the end of each day, the volume is recorded to a table. On my report, I have an average volume for each SKU for the report time period. I would like to have a sum of the averages at the bottom of the report. The problem is that I cannot seem to create an aggregate field of other aggregate fields.
I tried various formula with no luck. Basically what I am trying to do is something like:
When I use this, it says "Cannot have aggregate function in expression Sum(Avg([InvVolume])).Code:=Sum(Avg([InvVolume]))
Can anyone provide some insight as to how I can sum the averages for each SKU?
Note:I also tried adding a Total field from the Grouping & Totals, but it only allows me to add Number of Records.
Thanks in advance for any assistance.