Numeric Calculation Operations

Apply arithmetic, statistical, and mathematical functions to a numeric column.

Numeric calculation operations are available under Calculate > in the Numeric column context menu.

Numeric Calculate sub-operations

The following sub-operations are available:

Arithmetic

Applies a standard arithmetic operation between the selected column and a second operand (a fixed value or another numeric column in the Dataset).

Operator	Description
+	Addition
-	Subtraction
*	Multiplication
/	Division

Square Root

Calculates the square root of each value in the column. Output: √x.

Log

Calculates the natural logarithm (base e) of each value in the column. Output: ln(x).

Absolute

Returns the absolute value of each cell, removing the sign from negative numbers. Output: |x|.

Exp

Calculates the exponential function of each value. Output: e^x.

Square

Calculates the square of each value. Output: x².

Round to Integer

Rounds each numeric value to the nearest integer.

Round to Decimal

Rounds each value to a specified number of decimal places.

Example: 1.2345 rounded to 2 decimal places returns 1.23.