Math
Arithmetic operations on columns
What It Does
Math lets you write arithmetic expressions using column values. Create calculated fields like "price * quantity" or "(revenue - cost) / revenue".
How to Use It
Opening the Panel
Click the + button in the toolbar or press the operation picker, then search for "Math". It's in the Transform group.
Configuration
| Field | Type | Required | Description |
|---|---|---|---|
Expression | SQL expression | Yes | Arithmetic expression using column names |
Output | Apply Results Into | No | Write to existing or new column |
SQL generated under the hood
SELECT *, (revenue - cost) / revenue AS margin FROM dataRelated Operations
- Update Values - Update column values with expression
- Find & Replace - Search and replace values in a column
- Text Transform - Transform text: uppercase, lowercase, trim