average of averages?

[mrmookster]

I have a formula, @util which calculates the % utilisation as follows
(Sum ({@hrs_chargeable}, {@G3})/{#AvailableHrs}) * 100

my grouping is thus

G1
G2
G3
detail (suppressed) includes @hrs_chargeable, available_hrs
G3 F - @util
G2 F
G1 F

(this has been simplified - there are many more calcs accross the G3 F row, but they follow the same principle)

@hrs_chrageable is just a formula to identify chargeable hrs (in the detail section)
and {#AvailableHrs} is a running total of available_hrs

my problem is that in G2 i need to present an AVERAGE of the calculations in the formula @util

ie

G3 xxxx 85%
xxxx 81%
xxxx 60%
G2 75% (average of averages)

i know i can't do an average on a summary field but i thought i could do it using running total - but the formula @util is not available for selection

Please note... its an average of the averages that i need (not an average grouped by G2 - which i can get easily) enough .. and i know it doesn't make sense to me either... accountants?)

 

[IdoMillet]

One option is to use a Global variable to collect the sum of the averages. Then, divide it by the count of groups.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com