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!!
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!!