Summing a group summary formula

[zigstick]

Hello experts, I'm using Crystal Reports 2008 and have data that presents as: (in the group footer)

Status #Events Total Duration Average Duration FinalAvgDuration

Approved 2 37.12 18.56
Open 950 2079.48 2.19
... etc.

The Average Duration is calculated as below:
//Sum of duration for each status grouping (group 1) Divided by the Count of event records in each status group.
Sum ({Sheet1_.StatusDuration}, {Sheet1_.Status})/Count ({Sheet1_.Client}, {Sheet1_.Status})

For the last column, FinalAvgDuration, I need to show the groups avg duration/the SUM of all average durations.
Since the Average Duration is a group formula field, I'm unable to sum it for use the the FinalAvgDuration formula.

I've tried variations on the 3 formula method, but no luck. Any suggestions? Thanks much!!

 

[IdoMillet]

Use a variable to accumulate the values using a GF1 formula.
Then, access that variable in the RF section.

hth,
- Ido

view, export, burst, email, and schedule Crystal Reports.

http://www.MilletSoftware.com