Averaging Sums

[-cush-]

Group 1 : Employee Type (part time, full time, etc)
Group 2 : Employee Number
Group 3 : Pay Date

For group 3 I have a summary that adds the hours an employee worked in a pay period. Now in group 2 I need another Summary that averages those sums so that I have an average number of hours each employee works in all pay periods. It doesn't appear I can make a summary of a summary. I am guessing I will need to use some kind of running totals to calculate this but am not sure how to proceed. Any ideas?

 

[-cush-]

I guess all I need is a running total to show the number of pay periods per employee, put the total hours per employee and write a formula to divide the one from the other.

 

[-cush-]

That worked. Sorry for being lazy.

 

[kenhamady]

You can also do it without running totals:
Sum ({Hours}, {EmpNumber}) /
DistinctCount (PayDate},{EmpNumber})

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks

http://www.kenhamady.com/