Hi ,
We are trying to use the ROUND function in following code in a E-text template but it's not working with DIV .
Can anyone suggest on this !
IF(Salary_Frequency = 'Weekly')THEN
(
IF(Payroll_Frequency IS NOT NULL)THEN
(REPLACE((IF(Payroll_Frequency = ’Weekly’)THEN(Substr(Payroll_Runs,instr(Payroll_Runs,’|’,1,1)+1)*Normal_Working_Hours*(Assignment_Salary DIV Normal_Working_Hours))
ELSE IF(Payroll_Frequency = ’Biweekly’)THEN (Substr(Payroll_Runs,instr(Payroll_Runs,’|’,1,1)+1)*Normal_Working_Hours*2*(Assignment_Salary DIV Normal_Working_Hours)) ),’.’,’’))
END IF
)
END IF
Please let me to if you need any information from my end.
Thanks in advanced .