Apply Rounding to the Pay Rate

25-May-2023 · Wing Au Yeung

What is this?

Sometimes, you may want to apply the rounding to the Pay Rate instead of the Pay Amount.

Different payroll variables can be used for different rounding methods. You can apply different rounding methods, e.g Floor, Ceiling, Away to Zero to the Pay Rate with the number of decimal places you want.

What will the Value be Returned?

Returns the Pay Rate with the rounding method you want.

1. Usage

Hightlight part content can be changed

Payroll Variable Description Usage
ROUND([Pay Rate]) Round the Pay Rate AWAY to ZERO to the nearest integer Round off the Average Daily Wages to the nearest integer
ROUND([ADW])
e.g. 734.55 = round to 735, 734.34 round to 734
FLOOR([Pay Rate]) Round DOWN the Pay Rate away to zero to the nearest integer Round down the Average Daily Wages to the nearest integer
FLOOR([ADW])
e.g. both 734.55 & 734.34 round to 734
CEILING([Pay Rate]) Round UP the Pay Rate away to zero to the nearest integer Round up the Average Daily Wages to the nearest integer
CEILING([ADW])
e.g. both 734.55 & 734.34 round to 735

2. Parameters/Variations

Below Parameters/Variations can only be used for ROUND

Parameters/Variations Description Usage
,Number Round off the Pay Rate to the nearest decimal places Round off the Average Daily Wages to the 1 decimal places
ROUND([ADW],1)
e.g. 734.55 = round to 734.6, 734.34 round to 734.3

Round off the Average Daily Wages to the 2 decimal places
ROUND([ADW],2)
e.g. 734.556 = round to 734.56, 734.342 round to 734.34