Please enable JavaScript to view this site.

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.