The Expression Builder in Compensation Setup > Compensation Plans lets organizations create complex expressions for bonus calculations that match their compensation strategy.
In the Expression Builder, you can set up custom formulas to calculate bonus payouts. Dayforce uses these formulas to calculate and show bonus payouts in worksheet previews, manager’s worksheets, and single worksheets.
You can create custom expressions for bonus calculation scenarios, such as:
- Nonlinear payout models. For example, no payout below 80% achievement, full payout at 100%, and accelerated payouts beyond 120%.
- Applying additional multipliers on top of the existing bonus factors to reflect specific business conditions or performance criteria.
See Expression Builder Examples for Bonus Payouts.
In Compensation Setup > Compensation Plans, in the Bonus Payout Calculation section, the Expression Builder opens when you select the Custom calculation type and click Edit.
The Expression Builder includes an expression input area for adding formulas, an operator toolbar, and four tabs:
- Builder tab: Lists built-in functions and conditional logic.
- Error List tab: Shows validation errors and warnings.
- Referenced Variables tab: Tests values.
- Variable Library tab: Lists available variable names and their descriptions.
| Variable | Variable Name | Description |
|---|---|---|
| Bonus Eligible Salary | BonusEligibleSalary | The employee’s salary that’s eligible for a bonus. |
| Target Percentage (%) | TargetPerc | The employee’s target bonus percentage. |
| Target Amount | TargetAmt | The employee’s target bonus amount. |
| Bonus Factor Weight (This variable repeats for all metrics added in the Bonus Factors section with their respective IDs.) | BFWeight_id | The weight of the bonus factor when calculating how much of the target bonus is paid out. |
| Bonus factor Payout Factor (This variable repeats for all metrics added in the Bonus Factors section with their respective IDs.) | PayoutFactor_id | The percentage of each bonus factor that is automatically awarded to the employee when the configured target is met. |
Use the Calculate button in the operator toolbar to calculate and validate the custom expression. This button ensures that only valid and executable formulas are used for bonus calculations.
See Expression Builder Interface in the Expression Builder Guide.