I have a layout (report) that is grouped by an ID, Year and Month. When we get down to the month grouping, it is doing an average of wind speed (NRG1) for each month. At the end it averages all the months and then the grand summary it averages everything. The issue is that when I do the calculations the averages don't add up? The BIALKE Average should be closer to 8.86 and the Grand Average closer to 7. Did I do something wrong?
For the averages, I created a summary field using Average Of.
I've attached the report so you can see the numbers and the layout design
I did the same sort of report with summary field of Total and it worked fine.