Need Help for Calculating Grand Total

[dev777]

I have a grouping report which has 3 groups(Repname, ReqType and WOType).

Group1- Repname
Group2- ReqType
Group3- WOType

I need to calculate grand total of Avg_Survey_Time.

Avg_Survey_Time=Sum(SurveyTime)/Count(WorkOrder)

Rep has values = A12,A13,A14
ReqType has Values = Physical, New, Claim
WOType has values = Jobsite, Prospect, Telesurvey

My Report is like this,

A12 Avg_Survey_Time(hrs)
Physical
Jobsite 132.00
Prospect 22.72
New
Telesurvey 117.32
Jobsite 23.11
A13
Claim
Jobsite 219.78
Telesurvey 235.91


Grand Total ------------------------------> ? ? ?

 

[Turkbear]

Hi,
Do you want a Grand Total of the averages? Like
132+22.72+117.32+23.11+219.78+235.91 ? What would this tell you?

Do you want, instead, the average of all the averages?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Madawc]

If you want the various in the same place, you'd need to do a running total for each. The use of Crystal's automated totals is outlined at FAQ767-6524.

It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options. In this case, it probably makes no difference.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[dev777]

Yes, I want a Grand Total of the averages

 

[lbass]

You can use the same method as I suggested in your other post. Create a variable like this:

whileprintingrecords;
numbervar sumave := sumave + {@youraveformula};

Place this in the group section that contains the average. Then in the report footer use a formula like this:

whileprintingrecords;
numbervar sumave;

-LB

 

[dev777]

I already did it.

Thank you lbass. Hats off to you buddy...