| 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.5or 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.
...
