Add math column

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

Next lesson
Freight & Logistics
Retail & Ecomm
Automatically manage your CRM
Automatically update store inventory
Better, faster, more powerful reports
Custom metrics, anywhere
Ecommerce Marketing Flows
Ecommerce Operations Flows
Generate rich customer insights
Go beyond the limitations of spreadsheets
Intelligent search and email marketing
Manage unique products
Powerful, custom reporting
Quickly respond to low inventory
RevOps Use Cases
Set up triggered alerts (even complicated ones)
Support your Sales team
Use APIs without any code