Payroll- how to add week 1 and week 2 per employee?

[RoxSki]

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 2 weekly totals to add together for a grand payperiod total for Reg and OT?
please help.

 

[kray4660]

Unless I am missing something, another formula with the following (assuming names for the formulas) {@Reg Hours}+{@Overtime Hours}

I hope this helps.

 

[RoxSki]

I wish it was that easy. When I try to summarize week1 Reg Hours with week2 Reg Hours, I get the message fields can not be summarized!

 

[fisheromacse]

It seems to me like something is missing, but ...
what happens if you use variables?

{@HoursCalc}
numbervar r40;
numbervar o40;
(if Sum ({laborhed.payhours}, {laborhed.clockindate}, "weekly")>40 then r40 := 40 else r40 := Sum ({laborhed.payhours}, {laborhed.clockindate}, "weekly"));
(if Sum ({laborhed.payhours}, {laborhed.clockindate}, "weekly")>40 then o40 := (Sum({laborhed.payhours}, {laborhed.clockindate}, "weekly")-40) else o40 := 0);
r40 + l40

 

[fisheromacse]

EDIT: I have the variable wrong is the last line. l40 should be o40.

{@HoursCalc}
numbervar r40;
numbervar o40;
(if Sum ({laborhed.payhours}, {laborhed.clockindate}, "weekly")>40 then r40 := 40 else r40 := Sum ({laborhed.payhours}, {laborhed.clockindate}, "weekly"));
(if Sum ({laborhed.payhours}, {laborhed.clockindate}, "weekly")>40 then o40 := (Sum({laborhed.payhours}, {laborhed.clockindate}, "weekly")-40) else o40 := 0);
r40 + o40

 

[RoxSki]

thank you, I have not used variables yet. I will try it.
Do I put this in the employee group or the week group?

 

[RoxSki]

this doesn't work either.

 

[lbass]

You can use variables to collect each of the Reg and OT hours across employees. But you need to tell us your report structure. Please identify all groups by the field you are grouping on and explain at what group level(s) you want to see the totals for REG and OT.

-LB