Hi
i'm trying to summarize a formula to calculate daily overtime for employees. This report is grouped by employee and the total needs to be placed in a group footer summarizing a total for OT per employee.
The formula references a running total so i'm not sure if i will be able to do it.
formula=@dailyOT
runningtotal= ##dailytotal
@dailyOT = if {##dailytotal} < 8.00 then 0 else {##dailytotal} - 8.00
##dailytotal sums up {job_tran.a_hrs}
Ive tried to be as clear as I can, is there any way to do this?
i'm trying to summarize a formula to calculate daily overtime for employees. This report is grouped by employee and the total needs to be placed in a group footer summarizing a total for OT per employee.
The formula references a running total so i'm not sure if i will be able to do it.
formula=@dailyOT
runningtotal= ##dailytotal
@dailyOT = if {##dailytotal} < 8.00 then 0 else {##dailytotal} - 8.00
##dailytotal sums up {job_tran.a_hrs}
Ive tried to be as clear as I can, is there any way to do this?