Forum Discussion

s15's avatar
s15
Icon for Helper III rankHelper III
9 years ago
Solved

Convert a numeric to percetange after using measure

I have two values: Sales and Gross Sales. I created a measure to calculate the margin. The measure looks like below   Margin = 100 - (SUM(financials[ Sales])/SUM(financials[Gross Sales])*100)   ...
Need Help
  • MFelix's avatar
    MFelix
    9 years ago

    Hi s15,

     

    First of all change your measure to: 

    Margin = 1 - (SUM(financials[ Sales])/SUM(financials[Gross Sales]))

    Then just select the measure and on the bar choose Modeling and Percentage and your measure will be in %.

     

     

    Regards,

    MFelix

MFelix's avatar
MFelix
Icon for Super User rankSuper User
9 years ago

Hi s15,

 

First of all change your measure to: 

Margin = 1 - (SUM(financials[ Sales])/SUM(financials[Gross Sales]))

Then just select the measure and on the bar choose Modeling and Percentage and your measure will be in %.

 

 

Regards,

MFelix