Skip to main content
The Calculate tool is one of the most used tool. It helps you create new columns using math. The Calculate tool can be used with all basic math operations like addition, subtraction, division, multiplication. You can use it with the columns in your dataset or to create/add static calculations/numbers.
You can only reference numeric columns (integers/whole number or float/decimal columns) in the Calculate tool

​
Configuration

The Calculate tool has of two required input.
1

Input Column Name

The Calculate tool will create a new column. Use this input to name it.
2

Input Calculation

Simply type your calculation. Use + for addition, - for subtraction, * for multiplication and / for division. Remember to use parentheses to create order of operations.
Start typing a column name to reference it - for example Amount

​
When To Use

The possibilities are endless with the Calculate tool. Use it whenever you need to add a custom calculation.

​
Examples

I want to add an Exchange Rate column
I would like to add 100 to my value column
I would like to multiply a column with another column
I would like to calculate percentage difference

​
Advanced Syntax

Please reach out to us if you need additional advanced syntaxes
SyntaxDescription
[column].var()Variance
[column].median()Median
[column].sqrt()Square Root
[column].log(base=someNumber)Logarithm to a given base
[column].exp()Exponential
[column].hash()Hash the value