##### Page tree

Release 8.7.1

Contents:

Scheduled Maintenance: docs.trifacta.com will be offline for maintenance at 3:00pm UTC on Thursday March 30 for about 15 minutes.

The following example demonstrates how the rounding functions work together. These functions include the following:

• `FLOOR` - largest integer that is not greater than the input value. See FLOOR Function.
• `CEILING` - smallest integer that is not less than the input value. See CEILING Function.
• `ROUND` - nearest integer to the input value. See ROUND Function.
• `MOD` - remainder integer when input1 is divided by input2. See Numeric Operators

Source:

rowNumX
1-2.5
2-1.2
30
41
51.5
62.5
73.9
84
94.1
1011

Transformation:

Transformation Name `New formula` `Single row formula` `FLOOR(X)` `'floorX'`

Transformation Name `New formula` `Single row formula` `CEILING(X)` `'ceilingX'`

Transformation Name `New formula` `Single row formula` `ROUND (X)` `'roundX'`

Transformation Name `New formula` `Single row formula` `(X % 2)` `'modX'`

Results:

rowNumXmodXroundXceilingXfloorX
1-2.5 -2-2-3
2-1.2 -1-1-2
300000
411111
51.5 221
62.5 332
73.9 443
840444
94.1 454
10111111111