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 Tco...
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]) )  )

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]) )  )