cousinconley
MIS
Can someone tell me why I cannot run a total on the following formula:
stringvar PUNCHIN:={TC1_TimecardMastefile.TimePunchedIn};
stringvar PUNCHOUT:={TC1_TimecardMastefile.TimePunchedOut};
IF GroupName ({@SHIFT})="7AM TO 3PM" AND PUNCHOUT > "15.00" THEN VAL(PUNCHIN) - 15.00
Else
IF GroupName ({@SHIFT})="7AM TO 3PM" AND PUNCHIN < "07.00" THEN VAL(PUNCHOUT) - 7.00
Else
IF GroupName ({@SHIFT})="3PM TO 12AM" AND PUNCHOUT > "23.99" THEN VAL(PUNCHIN) - 24.00
Else
IF GroupName ({@SHIFT})="3PM TO 12AM" AND PUNCHIN < "15.00" THEN VAL(PUNCHOUT) - 15.00
Else
IF GroupName ({@SHIFT})="12AM TO 7AM" AND PUNCHOUT > "07.00" THEN VAL(PUNCHIN) - 7.00
Else
IF GroupName ({@SHIFT})="12AM TO 7AM" AND PUNCHIN <= "23.99"
THEN {TC1_TimecardMastefile.HoursWorked}-(Val(PUNCHIN)-23.99)
else {TC1_TimecardMastefile.HoursWorked}
PLEASE HELP!!!
stringvar PUNCHIN:={TC1_TimecardMastefile.TimePunchedIn};
stringvar PUNCHOUT:={TC1_TimecardMastefile.TimePunchedOut};
IF GroupName ({@SHIFT})="7AM TO 3PM" AND PUNCHOUT > "15.00" THEN VAL(PUNCHIN) - 15.00
Else
IF GroupName ({@SHIFT})="7AM TO 3PM" AND PUNCHIN < "07.00" THEN VAL(PUNCHOUT) - 7.00
Else
IF GroupName ({@SHIFT})="3PM TO 12AM" AND PUNCHOUT > "23.99" THEN VAL(PUNCHIN) - 24.00
Else
IF GroupName ({@SHIFT})="3PM TO 12AM" AND PUNCHIN < "15.00" THEN VAL(PUNCHOUT) - 15.00
Else
IF GroupName ({@SHIFT})="12AM TO 7AM" AND PUNCHOUT > "07.00" THEN VAL(PUNCHIN) - 7.00
Else
IF GroupName ({@SHIFT})="12AM TO 7AM" AND PUNCHIN <= "23.99"
THEN {TC1_TimecardMastefile.HoursWorked}-(Val(PUNCHIN)-23.99)
else {TC1_TimecardMastefile.HoursWorked}
PLEASE HELP!!!