Forum Discussion

AbbasG's avatar
AbbasG
Memorable Member
4 years ago
Solved

Calculating sales margin %

Hello All,

 

I have calculated the Sales margin value as below.

 

Sales Margin = SUM('Total Sales'[Total Sales Amount]) - (SUM(Cost[TCost]) + SUM(cog[Amount]))

 

cog = Cost of goods sold

Tcost = Total cost

 

I also want to calculate sales margin %. What would be the right query to achieve sales margin %?

Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    4 years ago

    AbbasG , Try like

    Sales Margin %= divide(SUM('Total Sales'[Total Sales Amount]) - (SUM(Cost[TCost]) + SUM(cog[Amount]), SUM('Total Sales'[Total Sales Amount]) )  )

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    AbbasG , Try like

    Sales Margin %= divide(SUM('Total Sales'[Total Sales Amount]) - (SUM(Cost[TCost]) + SUM(cog[Amount]), SUM('Total Sales'[Total Sales Amount]) )  )