AnsweredAssumed Answered

Average Issues

Question asked by SandyHaaf on Dec 14, 2012
Latest reply on Dec 14, 2012 by SandyHaaf

Title

Average Issues

Post


     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.

     Thanks,

     Sandy

ave_layout_2.jpg

Outcomes