derived field in Reportsmith 4.2

[walkerj]

I've created the following derived field to calculate a weekly hours field based on the employee's standard hours in ADP PCPW ver 5.10. It works well but I need to expand it further to include the same calculation when the employee's pay frequency = B. When I attempt to add to this decode formula, it errors. Any help is greatly appreciated!

DECODE("REPORTS"."V_EMP_ALL"."PAYFRQ",'M',"REPORTS"."V_EMP_ALL"."STANDARDHOURS" * 12 / 52)

 

[CharlesCook]

Try something like this:

DECODE("REPORTS"."V_EMP_ALL"."PAYFRQ",
'M',(("REPORTS"."V_EMP_ALL"."STANDARDHOURS" * 12) / 52),
'B',"REPORTS"."V_EMP_ALL"."STANDARDHOURS")

http://CharlesCook.com

Specializing in ReportSmith Training and Consulting

 

[walkerj]

Very helpful. I was able to complete my calculation. Thank you much