I'm STILL working on my payroll reports. One last hangup and then I think I've got it! Problem: When I run this report it's based on a two week pay period. I'm trying to calculate Overtime (OT) per week. Right now my OT formula basically says
if department. hours > 80 then
department.hours - 80.
The problem is, is that an assoicate can work 42.00 hours (2 hours OT) in one week but only work 16 hours in the second week. They would not accumulate a total of 80 hours and therefore not paid the 2 hours of OT they earned in week one. Make sense?
What I need to be able to do is look at each week individually to determine if OT conditions were met...just not sure how. I think a subreport will be needed and maybe some date parameters...but I'm really at a loss. Any help would be appreciated!
IP Logged