Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Tips and Tricks
Message Icon Topic: Average Group totals.... Post Reply Post New Topic
Author Message
Harleyquin
Newbie
Newbie
Avatar

Joined: 17 Sep 2008
Location: United Kingdom
Online Status: Offline
Posts: 3
Quote Harleyquin Replybullet Topic: Average Group totals....
    Posted: 04 Nov 2008 at 7:50am
Hi,
 
So I have tome values:
 
1
2
3
6
1
2
 
then I sum them up and in my group its 15.
 
we have a report that does this a few times so now we have them in groups...
 
GP total: 12
GP total: 10
GP total: 5
GP total 11
 
you get the idea - so the groups are a sum of the details... now what I want to do is the average of the totals!
 
if I just try to do the average of the details I'm going to be getting the wrong data - I need to do the average based on the group totals alone.
 
is this possible?


Edited by Harleyquin - 04 Nov 2008 at 7:52am
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 07 Nov 2008 at 5:45am

Hi

Create running total and place it in Group Footer

Select the  same value field as for group total

Type of Summary Average

Evaluate for Each Record

Reset On Change of Group

 

Cheers

Rahul

 

IP IP Logged
Harleyquin
Newbie
Newbie
Avatar

Joined: 17 Sep 2008
Location: United Kingdom
Online Status: Offline
Posts: 3
Quote Harleyquin Replybullet Posted: 07 Nov 2008 at 6:21am
sorted
 
 
thanks :)
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.031 seconds.