With the Add math column step, you can write formulas to calculate numeric values — similar to how you might in a spreadsheet. 

Building challenge

• Add a card titled “Calculate revenue” after our “Format currency values” card, and drop an Add math column step on the card.
• Create a column called Revenue, which is equal to units times price.
• After the step, add another Format numbers step to the same card, and format the newly created Revenue column as currency with two decimal places 

To check your work, take a look at this quick video.

How to use the step

1. Drag an Add math column step onto the canvas. 
2. After naming your columns, type in custom formulas using curly brackets ({}) to reference values within your columns. 
   • Ex) {Price}*{Units}

Pro tip

• Search for familiar functions: If you’re looking to replicate an Excel function, use Parabola’s search feature to find equivalent steps. For example, searching for “SUMIF” will display relevant steps that perform similar functions.
• Break down complex formulas with ChatGPT: For complex Excel formulas, consider using ChatGPT to generate a breakdown of the formula’s components. You can then paste that step-by-step right into a card to keep your Flow well documented. 

To learn more, check out our support docs.