Numeric Calculation Operations

Here are the 'Calculation' operations for Numeric type transformation

Calculations

Arithmetic

Returns the result of the chosen arithmetic operation on the selected column as the first attribute and the second attribute chosen.

The second input attribute can be a fixed value or another numeric column in the dataset.

Square Root

Calculates the square root of the values in the selected column.

Log

Calculates the natural logarithm of the values in the selected column to the base of the mathematical constant e.

Absolute

Calculates the absolute value of the cells in the selected column.

Exp

Calculates the exponent of the numeric value in the column.

Square

Calculates the square of the numeric value in the column.

Round to Integer

Rounds the numeric value to the closest integer.

Round to Decimal

Rounds the provided decimal value. Example 1.2345 rounds to 2 decimal places will give 1.23