The Insert math column step executes a math equation on each row of data. This step functions similarly to writing a formula in a new Excel column.

Insert math column

Input/output

Our input data has two rows of data: one for last week and one for this week, showing us how many Apples, Oranges, and Pears we sold.

After connecting the data into this step, it produces the output of a new column "Total Goods Sold" that shows calculations of the number of apples, oranges, and pears sold last week and this week.

Settings

First, connect your flow's most recent step to this one and choose a New Column Name.

Then in the Calculation field, enter your formula. Be sure to wrap your column names in {curly braces}. As you write your formula, you'll notice that column names are selectable for auto-completion. This is handy for when you have large datasets with many columns.

Your formula will be verified while you write it. If you see the green checkmark, it means your formula is correct and good to go!

If you see a red question mark, your formula has an error. Check to make sure your headers are correctly entered, or that you're using the correct mathematical notation.

You can add as many calculations as you'd like by clicking Add Math Rules. For example, if you'd like to add a new "Yearly Forecast" column that predicts the Total Goods Sold in a year based on the weekly sold quantity, you can multiply your Total Goods Sold column by 52 weeks in a year to instantly generate those results.

Click Show Updated Results to save your selections and the step's settings are now complete! Your new columns will display your calculations on a row-by-row basis.

Helpful tips

If you'd like to use a new column you just created using the Insert math column step in a previous formula, connect another Insert math column step to this one.

The Insert math column step can handle positive and negative numbers with currency symbols, percentage symbols, decimals, and commas. There is no need to reformat these numbers in order to use them in this step. If your number is in the accounting format, you will need to use the Format numbers step to change the formatting before using it in this one.

Insert math column

Input/output

Our input data has two rows of data: one for last week and one for this week, showing us how many Apples, Oranges, and Pears we sold.

After connecting the data into this step, it produces the output of a new column "Total Goods Sold" that shows calculations of the number of apples, oranges, and pears sold last week and this week.

Settings

First, connect your flow's most recent step to this one and choose a New Column Name.

Then in the Calculation field, enter your formula. Be sure to wrap your column names in {curly braces}. As you write your formula, you'll notice that column names are selectable for auto-completion. This is handy for when you have large datasets with many columns.

Your formula will be verified while you write it. If you see the green checkmark, it means your formula is correct and good to go!

If you see a red question mark, your formula has an error. Check to make sure your headers are correctly entered, or that you're using the correct mathematical notation.

You can add as many calculations as you'd like by clicking Add Math Rules. For example, if you'd like to add a new "Yearly Forecast" column that predicts the Total Goods Sold in a year based on the weekly sold quantity, you can multiply your Total Goods Sold column by 52 weeks in a year to instantly generate those results.

Click Show Updated Results to save your selections and the step's settings are now complete! Your new columns will display your calculations on a row-by-row basis.

Helpful tips

If you'd like to use a new column you just created using the Insert math column step in a previous formula, connect another Insert math column step to this one.

The Insert math column step can handle positive and negative numbers with currency symbols, percentage symbols, decimals, and commas. There is no need to reformat these numbers in order to use them in this step. If your number is in the accounting format, you will need to use the Format numbers step to change the formatting before using it in this one.

Updated on: 12 / 05 / 2022