Round step
Returns to the nearest whole (integer) number. Mathematical rounding is used - values ending in digit 5 will be rounded away from zero, values less than 5 will round towards zero.
Parameters
-
Input column: a number to round, must be a decimal column.
-
Precision: specifies the number of digits to round the input to
-
0: round to whole numbers.
-
Positive value: round to specified number of decimal places.
-
Negative value: round to multiples of 10, 100, etc.
-
-
Target column: configure the column which will receive the output. Output will always be of decimal type.
-
Write result to the current column: overwrite the input column with the result.
-
Create new column with name: create a new column with specified name. Name of the new column can contain spaces or special characters - technical column name will be created automatically. The new column will be placed right after the input column.
-
Examples
| Input value | Precision | Output value |
|---|---|---|
Description |
4.125 |
0 |
4 |
Rounds to the nearest whole number. |
-4.125 |
0 |
-4 |
Rounds to the nearest whole number. |
4.125 |
1 |
4.1 |
Rounds to one decimal place. |
-4.125 |
1 |
-4.1 |
Rounds to one decimal place. |
4.125 |
2 |
4.13 |
Rounds to two decimal places. |
-4.125 |
2 |
-4.13 |
Rounds to two decimal places. |
453.4 |
-1 |
450 |
Rounds to the nearest multiple of 10. |
453.4 |
-2 |
500 |
Rounds to the nearest multiple of 100. |
|
(any) |
Error |
Remarks
-
Applying the step to No value cells (cells containing null) will result in an error.
See also
-
roundfunction in CTL.