D toc |
---|
Excerpt |
---|
Rounds input value to the nearest integer. Input can be an Integer, a Decimal, a column reference, or an expression. Optional second argument can be used to specify the number of digits to which to round. |
- When rounding to nearest integer, decimal values that are
X.5
or more are rounded toX+1
.
...
Output: Generates a column containing the nearest integer to the sum of 2.5 and the value in the MyValue
column.
Numeric literal example:
D code |
---|
derive type:single value:ROUND(PI(),4) |
Output: Generates a column containing pi rounded to four decimal points: 3.1416
.
...