Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 11 Jun 2012 at 5:15am
You can't do an average of an average - it's an invalid statistic. I assume that you're doing the averages by group for what you have. What you need to do to get the final average is run the average as a Grand Total instead of by group. This will sum the scores for all records and divide by the total number of scores on the report.
Joined: 20 Dec 2011
Location: England
Online Status: Offline
Posts: 259
Posted: 11 Jun 2012 at 5:27am
I still wouldn't even try and take an average of an average even if there is a method that allows it - it's a meaningless number, the average test score in your example is 44, not 42.5.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum