Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

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 to X+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.

...