Forum Discussion

MHongisto's avatar
MHongisto
Frequent Visitor
9 years ago
Solved

Quick measure - Percentage difference

If I want to calculate percentage of costs vs sales amounts, I tried using the quick measure percentage difference. It gave me this code:   Measure1 % difference from Sales amount = VAR __BASELINE...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    Hi MHongisto,

     

    "Percentage difference" is under the submenu "Mathematical operations". It looks like a math theory, which evaluates the difference and compare with the base value. Please refer to Percent of Increase or Decrease if you'd like to.

     

    Best Regards!

    Dale

MHongisto's avatar
MHongisto
Frequent Visitor
9 years ago

The Quick measure - Percentage difference calculation automatically puts the subtraction in DIVIDE. I don't understand why. Bug or feature?

cs_skit's avatar
cs_skit
Resolver IV
9 years ago

Its a Percentage DIFFERENCE

Its just a recommendation.

It makes sense in many scenarios like:

 

Base 1000 Value 1020

Quick measure gives you 2%

 

Does not mean that its always correct in your specific scenario if you don't want 2% but 102% then you don't subtract.

Theres no right and wrong here depends on what you need.