Expression Builder Interface

Expression Builder Guide

Version
R2025.2.0
ft:lastEdition
2025-10-20
Expression Builder Interface

The Expression Builder is an environment in Payroll Setup > Earnings and Deductions, in which you can write and test expressions. When working with generated earnings or deductions, in the Parameters tab, you select the Expression calculation type, as illustrated here: 

Earning Parameters tab with the Expression option selected in the Calculation Type drop-down list.

Enter expressions in the Expression area. You should manually type your expressions rather than copying and pasting them from another source. Copying and pasting can introduce hidden characters that the Expression Builder doesn’t recognize, which can result in errors.

Add parameters (which are discussed in Parameters) to the expression to enable it to reference calculated earnings and deductions.

The Expression Builder checks the format and syntax of an expression as you type it. If there are any errors, it displays them in an error list as shown below:

Error window.

The error window describes the error and on what line of the expression you can find it.

You can also ensure that your expressions work properly by entering test values for parameters in the Test Value fields in the Configurable Parameters and Calculated Parameters tabs, and then clicking Calculate, as shown below:

Highlighted Run Test button.

The Expression Builder displays the results of the calculation beside Calculate.

After you save an expression, it is locked. If a pay run using the deduction that is associated with the expression has been committed, you cannot edit the expression. However, if the pay run hasn't been committed you can still edit the expression. To do so, you can unlock it by clicking the Confirm button after opening the definition for a deduction or earning.