Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Summing a group summary formula

Status
Not open for further replies.

zigstick

Technical User
Jun 1, 2006
50
US
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!!
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top