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
- Drag an Add math column step onto the canvas.
- 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.