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

...

Numeric literal example:


ROUND
d-codelang-syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive type:single value:
round(2.5)

...

round(2.5)


Output:
Rounds the input value to the nearest integer: 3.

Expression example:

ROUND
d-codelang-syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive type:single value:
round(MyValue + 2.5)

round(MyValue + 2.5)

Output:

...

Rounds to the nearest integer

...

the sum of 2.5 and the value in the MyValue column.

Numeric literal example:

ROUNDPI
d-codelang-syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive type:single value:
round(
pi(),4)

round(pi(),4)

Output: Generates a column containing Rounds pi rounded to four decimal points: 3.1416.

D s
snippetSyntax

ROUND
d-codelang-syntax
RawWrangletrue
Typesyntax
showNotetrue
WrangleTextderive type:single value:
round(numeric_value, integer_value)

round(numeric_value, integer_value)


ArgumentRequired?Data TypeDescription
numeric_valueYstring, decimal, or integerName of column or Decimal or Integer literal to apply to the function
integer_valueNinteger

Number of digits to which to round.

  • Default is 0, which rounds to the nearest integer.
  • Negative integer values can be applied.

...