Custom Calculation Operation

Build a custom mathematical formula using columns, functions, and operators, following BODMAS order of operations.

The Custom Calculation operation opens a formula builder where you compose an expression applied to every row in the Dataset.

Custom Calculation dialog
Custom Calculation formula builder

Configuration

Field / Control
Description

Columns β€” Select

Dropdown to insert a column reference into the formula.

Functions β€” Select

Dropdown with a search box to insert a mathematical function. Available functions include: Log, Sin, Cos, Exp, Tan, and more.

Operator buttons

Round buttons for (, ), +, βˆ’, /, * β€” click to insert into the formula at the cursor position.

Formula area

The editable formula text area, pre-populated with the current column name.

Create New Column

When enabled, writes the result to a new column instead of overwriting.

Column Name

The name of the new column.

πŸ’‘ Note: Formulas follow BODMAS order of operations β€” Brackets, Orders (powers/roots), Division, Multiplication, Addition, Subtraction.

Last updated