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 |