Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Tips and Tricks
Message Icon Topic: Average of Average Post Reply Post New Topic
Author Message
ipavlova
Newbie
Newbie
Avatar

Joined: 30 May 2012
Online Status: Offline
Posts: 3
Quote ipavlova Replybullet Topic: Average of Average
    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
                                      
 
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet 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
IP IP Logged
rkrowland
Senior Member
Senior Member
Avatar

Joined: 20 Dec 2011
Location: England
Online Status: Offline
Posts: 259
Quote rkrowland Replybullet 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.
IP IP Logged
comatt1
Senior Member
Senior Member
Avatar

Joined: 19 May 2011
Online Status: Offline
Posts: 337
Quote comatt1 Replybullet 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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.023 seconds.