Notion – Calculate total COGS from multiple number fields (properties)

Are you setting up Notion templates with formulas for your team? Add this formula in one of our expert-created Notion templates.

See our finance templates

Notion Formula: Calculate total COGS from multiple number fields (properties)

The formula is:

prop(“Total Sales Number Field”) * prop(“Cost Of Goods”)

↑ Copy and paste into Notion then switch out the bold property name/s in the formula to match the name of the property name/s you’re using.

 

How to create a number formula in Notion

The steps to creating a number formula in Notion are:

  1. Create a Notion page
  2. Add a Notion database using the command /database (choose Database – Inline for this example)
  3. Add a column (property) by clicking on the + icon to the right of the existing column (property) name
  4. Select Number
  5. Add more properties for each number you’re using to calculate
  6. Add another column (property) and scroll down to select Formula
  7. Click Edit next to the word Formula
  8. Add your formula in the grey box titled “Type a formula” and then click Done

 

How to edit a number formula in Notion

The steps to editing a number formula in Notion are:

  1. Click on the column (property) name and select Edit Property
  2. Click Edit next to the word Formula
  3. Edit your formula in the grey box and then click Done