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:
| rowNum | X |
|---|---|
| 1 | -2.5 |
| 2 | -1.2 |
| 3 | 0 |
| 4 | 1 |
| 5 | 1.5 |
| 6 | 2.5 |
| 7 | 3.9 |
| 8 | 4 |
| 9 | 4.1 |
| 10 | 11 |
Transformation:
| Transformation Name | New formula |
|---|---|
| Parameter: Formula type | Single row formula |
| Parameter: Formula | FLOOR(X) |
| Parameter: New column name | 'floorX' |
| Transformation Name | New formula |
|---|---|
| Parameter: Formula type | Single row formula |
| Parameter: Formula | CEILING(X) |
| Parameter: New column name | 'ceilingX' |
| Transformation Name | New formula |
|---|---|
| Parameter: Formula type | Single row formula |
| Parameter: Formula | ROUND (X) |
| Parameter: New column name | 'roundX' |
| Transformation Name | New formula |
|---|---|
| Parameter: Formula type | Single row formula |
| Parameter: Formula | (X % 2) |
| Parameter: New column name | 'modX' |
Results:
| rowNum | X | modX | roundX | ceilingX | floorX |
|---|---|---|---|---|---|
| 1 | -2.5 | -2 | -2 | -3 | |
| 2 | -1.2 | -1 | -1 | -2 | |
| 3 | 0 | 0 | 0 | 0 | 0 |
| 4 | 1 | 1 | 1 | 1 | 1 |
| 5 | 1.5 | 2 | 2 | 1 | |
| 6 | 2.5 | 3 | 3 | 2 | |
| 7 | 3.9 | 4 | 4 | 3 | |
| 8 | 4 | 0 | 4 | 4 | 4 |
| 9 | 4.1 | 4 | 5 | 4 | |
| 10 | 11 | 1 | 11 | 11 | 11 |
This page has no comments.