RoxSki
Technical User
- Dec 20, 2012
- 6
I am attempting to convert our company's payroll to Crystal version 11.5.12.1838. I am not a pro at Crystal but I do know more than just basic reporting. I have to use a formula for pay hours (not just the pay hours field). I can't seem to get the
Reg Hours: (if Sum ({laborhed.payhours}, {laborhed.clockindate}, "weekly")>40 then 40 else Sum ({laborhed.payhours}, {laborhed.clockindate}, "weekly"))
and the
Overtime Hours: if Sum ({laborhed.payhours}, {laborhed.clockindate}, "weekly")>40 then Sum ({laborhed.payhours}, {laborhed.clockindate}, "weekly")-40 else 0
to add together! I have read posts and forums.....
How to I get the weekly totals to add together for a grand payperiod total for Reg and OT?
please help.
Reg Hours: (if Sum ({laborhed.payhours}, {laborhed.clockindate}, "weekly")>40 then 40 else Sum ({laborhed.payhours}, {laborhed.clockindate}, "weekly"))
and the
Overtime Hours: if Sum ({laborhed.payhours}, {laborhed.clockindate}, "weekly")>40 then Sum ({laborhed.payhours}, {laborhed.clockindate}, "weekly")-40 else 0
to add together! I have read posts and forums.....
How to I get the weekly totals to add together for a grand payperiod total for Reg and OT?
please help.