Print Page | Close Window

Average of Average

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=16657
Printed Date: 18 May 2024 at 9:30am


Topic: Average of Average
Posted By: ipavlova
Subject: Average of Average
Date Posted: 02 Jun 2012 at 8:58pm
Hi,

I have a summary fields that include the Average score of users.

What i need to do is do an Average of these  fields (i mean average of all users score).
 
The data is  like this:
Group of learners "New hires":
Learner 1
     Test 1 score: 20
     Test 2 score : 50
                     average: 35   - for this fields i use RTotal field
 
Learner 2
    Test 1 score: 20
    Test 2 score : 100
    Test 3 score: 30
                   average: 50 
 
And the result  must be: Average for all users: 42,5
                                      
 


Replies:
Posted By: hilfy
Date 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.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: rkrowland
Date 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.

Posted By: comatt1
Date Posted: 31 Aug 2012 at 5:55am
I would weight the scores, then average, like if new then score x2 and if old scorex1 or something


Print Page | Close Window