[Crystal Reports] Calculate An Average Based of A Global Variable

[Epyon]

Hey,

I've basically got an issue here, I have my report setup to have groups for each set of records and within those groups I've programmed something to basically take the start and end date of each record and give me the time spend in minutes (which I then format into hours, minutes, etc). Now the problem is at the end of each group I was the report to show the average time per group. I've tried making a variables which increases after each record however it doesn't reset after each group and instead has turned into a running total.

Does anyone have any ideas?

 

[Fezzer]

You will need to use another formula, I normally put it in the group header, to manually reset the value of the global variable at the beginning of each group.

Shout if you want more detail.

 

[Pho]

This sounds like a job for running totals.