Print Page | Close Window

Average Group totals....

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=4719
Printed Date: 29 Apr 2024 at 10:03am


Topic: Average Group totals....
Posted By: Harleyquin
Subject: Average Group totals....
Date 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?


Replies:
Posted By: rahulwalawalkar
Date 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

 

Posted By: Harleyquin
Date Posted: 07 Nov 2008 at 6:21am
sorted
 
 
thanks :)


Print Page | Close Window