Average of a Group Formula Field

[rhammond]

Here's my issue:
I have a report where Group 1 is the Date, and Group 2 is the time. I've got a field where in order to get the data I need, I create a sum of this field (represents a value in seconds for the record) in Group 2, suppress it, and then have a formula that is displayed (Sum ({field}, {Time Value}, "by hour&quot / 3600) - 3600 being the number of seconds in an hour.

I want to Summarize it in Group 1 (Date), but instead of a total, I want the Average of my formula field. I've racked my brain with no luck - does anyone have any suggestions? Thanks in advance!

 

[lbass]

Hi-

You should be able to do this using the running total expert as follows:
Select {@your formula} and choose "Average"
Evaluate on change of Group 2
Reset on change of Group 1

The results need to be displayed in the Group 1 footer, not header.

-lb