Sum Group Counts?

[loveyoursite]

CRV10. My report has three groups.
1. Cost Center
2. Department
3. Pay Period Ending - this group has a summary distinct count of employees paid during each pay period.

In group 2 - Department - I need a distinct count of employees paid for ALL of the pay periods. I use a distinct count in each pay period because each employee may be listed more than once during a pay period due to different kinds of hours, i.e. regular, overtime, vac, etc but I only want to count that employee once for that pay period.

For example, department XYZ may have 6 pay periods with 12 distinct employees paid. Department ABC may have 3 pay periods with 8 distinct employees paid. In the department group footer, I need to add 12 + 8 for a total of 20 paid.

End Result should be:
Cost Center 0123, Total employees paid for all departments, all pay periods = 20

I would appreciate any adivse on how I can take each Pay Period Ending distinct count and add them all together for a total department count (all pay periods).

Thanks!

 

[pajon]

Hi, loveyoursite...

If I understand you correctly, I would use a global shared variable as a counter.

Dimension it in the report header, and clear it each Cost Center group header. Add your disctinct count in each Pay Period Ending footer to the global variable, reference it and display it in the Cost Center footer, and then the next Cost Center header will start the process again.

In the formula for the accumulator, you could have a second summary variable that would yield the total account of the whole report.

Admittedly, I work with 8.5, and that is the ONLY way you could do this, 10 might have some neato new features that I'm unaware of.

Hope that helps!