Print Page | Close Window

Help with summary functions

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=9252
Printed Date: 03 May 2024 at 5:15pm


Topic: Help with summary functions
Posted By: radibhatla
Subject: Help with summary functions
Date Posted: 01 Mar 2010 at 3:13pm
Hi,
 
In my report I have three groups no cycle, summer cycle and and winter cycle and each of the above groups are further subdivided into s0,s1...s5.
 
S0 - s5 have a set of two rows each.
 
I have to calculate the mean, standard deviation(SD) and the c.v(i.e mean/SD*100) for S0,S1, S2... s5 for all the  three groups nocylce, summer cycle and winter cycle. i used the below formula
 
Average ({Command.I_RLU},{@cycle cat} )
 
I am able to do this fine.
 
But I am stuck when I have to divide the mean of S0 in the nocycle group by the mean of S0 in the Winter cycle group.
 
How can I write a formula which distinguishes the mean of S0 in the No cycle group from the mean of S1 in the Winter cycle group.
 
Any help will be appreciated


Replies:
Posted By: DBlank
Date Posted: 02 Mar 2010 at 7:06am
You can create Running Totals as specific values and use them in a formula. The formula must be placed below the values it is using (footers below last record in all groups referenced.
IN the evaluate part use a Formula as field=Winter Group
and Reset to Never. 


Print Page | Close Window