ROUND |
Scroll |
The ROUND function performs rounding on a decimal number in accordance with a user specified precision.
Category
Mathematical
Syntax
ROUND(decimal_value, scale)
Parameter Descriptions
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
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.
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.