Summary of Hours Worked in a Year

[alatham]

Hello,

I would like to pull the total hours worked for employees in a given year and I would like this data on a single line (i.e., not by pay period).

I can get it by pay period via a derived field but this produces 26 lines (for bi-weekly payroll).

Instead of this:
Employee Hrs Worked
John Smith 80
John Smith 80
etc, 26 times

I would like this:
Employee Hrs Worked
John Smith 2080

(2080 being 80 hours multiplied by 26 pay periods. Obvioulsy not all employees are going to be this consistent in their total hours.)

Advice and examples greatly appreciated!

Thanks in advance,
Adam

 

[CharlesCook]

The trick is using Database Grouping. How you group the data will determine how many lines you get back (or how the data is compressed).

Start by looking at this:

http://charlescook.com/PPS/ADP/ReportSmith/PCPW/DatabaseGrouping.pps

Charles Cook
Charles@CharlesCook.com

http://CharlesCook.com

Specializing in ReportSmith Training and Consulting