The ROUND function performs rounding on a decimal number in accordance with a user specified precision.
Category
Mathematical
Syntax
ROUND(decimal_value, scale)
Parameters and Descriptions
| Parameter | Description |
|---|---|
| decimal_value | A decimal number from a source datastore field/column, user specified numeric value, variable or the numeric result of another Function. |
| scale | Specifies the precision (the number of digits right of the decimal point) to be returned with the result of the rounding operation. |
Example 1
Round the source field INPUT_NUM, where INPUT_NUM is 12.3377 and return the results with a precision of 2. Map the result to target field ROUNDED_NUM
ROUNDED_NUM = ROUND (INPUT_NUM, 2)
Returns the value of 12.34 and maps it to the target field.
Example 2
Round the number 43.655423 and return the results with a precision of 3. Map the result to target field ROUNDED_NUM.
ROUNDED_NUM = ROUND (43.655823, 3)
Returns the value of 43.656 and maps it to the target field.