Transforming data

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 by row and assign statuses” after our “Reformat date values” card, and drop an Add math column step on the card.
  • Within the Add math column step, create a column called Revenue, which is calculated by doing Line Item Price times Units 

Check your work

Image 1 Image 2

Next lesson