The following table describes the arguments for this command:

Numeric value.

If one of the arguments is NULL, ROUND returns NULL.

The following expression returns the values in the Price port rounded to three decimal places:

You can round digits to the left of the decimal point by passing a negative integer in the

precision

argument:

If you pass a decimal value in the

precision

argument, the

Data Integration Service

rounds it to the nearest integer before evaluating the expression:

If you omit the

precision

argument, the function rounds to the nearest integer:

You can also use ROUND to explicitly set the precision of calculated values and achieve expected results. When the

Data Integration Service

runs in low precision mode, it truncates the result of calculations if the precision of the value exceeds 15 digits. For example, you might want to process the following expression in low precision mode:

In this case, the

Data Integration Service

evaluates the left hand side of the expression as 6.999999999999999 because it truncates the result of the first division operation. The

Data Integration Service

evaluates the entire expression as FALSE. This may not be the result you expect.

To achieve the expected result, use ROUND to round the truncated result of the left hand side of the expression to the expected result. The

Data Integration Service

evaluates the following expression as TRUE: