Round up/down

Rounds the values from a numerical source column to the specified number of decimal places (accuracy), writes the results to the target column, and overwrites any existing values there. If the target column does not exist, it is created.

If the accuracy itself is specified as a decimal number, the decimal places are ignored, that is, the integer value is used. Values that already have the same number or fewer decimal places than specified remain unchanged.

When rounding, the value is rounded down if the next decimal place is < 5, otherwise it is rounded up.

The following parameters are available.

Action

Result

Source column

Name of the source column whose values are rounded.

Source: Source table

Data type: Number

Specification: Mandatory

Precision

Numerical value specifying the number of decimal places;

Source: Source table, single-value operator, input value, or a constant.

Data type: Number

Specification: Mandatory

Target column

Name of the column to which the result is written. The column name can be transferred from the source table or freely entered.

Data type: Number

Default value: Result_1

Specification: Optional