Add math column

Input/output

Our input data has two rows of data: one for last week and one for this week, showing us units sold of a few different types of fruit.

After connecting the data into this step, it produces a new column, 'Total Goods Sold', that shows the total number of fruits sold each 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 (e.g.: '{Apples}'). 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 'Settings error', as below, your 'Calculation' box likely has a typo. 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 to instantly generate that figure.

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