Formula : How to set lateness formula using IF ELSE function in deduction?

Created by Auto Count Support, Modified on Fri, 18 Apr at 12:01 PM by Auto Count Support

Print

This guide will assist you in setting up lateness formula using the IF ELSE function in for the deduction purposes.


To setup a lateness deduction formula using the IF ELSE function, go to Tools > General Maintenance > Deduction.


Click on the Add New button.



Maintain the Deduction Code, Description and determine the statutory setting and then click on Formula to set the formula. You may set the formula as below.

EXAMPLE: 

IF (LATENESS TIME <= 30 AND LATENESS TIME < 60) 100 ELSE IF (LATENESS TIME >= 60 AND LATENESS TIME < 90) 200 ELSE 0.

 

Fill in all the necessary details and click on Save once done to save the changes made.



The deduction for lateness is set and ready to use.



Ensure that you have extracted the Lateness Time in Time Attendance Import.



Process the employee’s payroll and the deduction should reflect inside.


END OF GUIDE




Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article