Add 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.

Custom 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.

If you see a the error below, 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 created using the Add math column step in a previous formula, connect another Add math column step to this one.
• The Add 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.
• This step currently supports the Addition ( + ), Subtraction ( - ), Multiplication ( * ), Division ( / ), Modulo ( % ), and Power ( ^ ) operators