Formula operators
You can use standard mathematical operators in formulae.
Symbol | Meaning |
---|
+ | Add |
- | Subtract |
* | Multiply |
/ | Divide |
% | Percent |
( | Left bracket |
) | Right bracket |
TIP: Formulas use the mathematical order of operations - equations in brackets calculate first.
Enter a formula for a deduction
- Click Company / Payroll, then click Deductions.
- Select the relevant deduction, then click Edit.
- In the Advanced section, in the Employee Formula box, enter the content.
- To enter a formula for the employer's contribution, in the Employer Formula box, enter the content.
- Click Save, then click Close.
External formula
Sometimes, the formula you require is too long to fit in the formula fields in the payment or deduction element settings. Enter the required formula in a text file with a .fml extension. Store the .fml file in the Sage Payroll Data Directory. In the formula field in the formula section of the payment or deduction, enter the following:
program "formula.fml"
This will enable a longer and more complex formula to apply to your employee's timesheets.
Have a formula designed for you
To save you time, we offer a chargeable formula design service. Our senior specialist can create a custom formula for all types of scenarios that require processing each pay period. For more information, Contact us.