Rounds double values to the specified decimal place or significant figures, applying the specified rounding method. The columns containing the double values can be specified. The rounded values can be appended as additional columns, or the old values are replaced by the rounded values. If rounded values are appended as additional columns, a column suffix for the columns to append needs to be specified.
To round the values seven different rounding modes are available: UP, DOWN, CEILING, FLOOR, HALF_UP, HALF_DOWN, HALF_EVEN. For the detailed description of each rounding mode please see the Java documentation .
The output formatting can be of different types, which are described by example below. Rounding the numbers 1.23501, 0.00000035239 and -3.123103E9 to 3 significant digits (HALF_UP) will produce:
| Input | Double(*) | Standard String | Plain String (no exponent) | Engineering String |
|---|---|---|---|---|
| 1.23501 | 1.24 | "1.24" | "1.24" | "1.24" |
| 0.00000035239 | 0.000000352 | "3.52E-7" | "0.000000352" | "352E-9" |
| -3123103001 | -3120000000 | "-3.12E+9" | "-3120000000" | "-3.12E+9" |
(*)Note that the "Double" output option may yield unexpected results due to numerical precision issue when representing floating point numbers. For example a number such as 0.1 can sometimes be represented as 0.09999999999999999.