Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculate %-difference between two data points in different series

Hi, I have two measures with one data point in each and I want to calculate the %-difference between these in a card, how can I do that correctly?  The formulas for the measures are as follows: Q...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous 

    One if the two


    Difference % = divide([Quantity Last Period] - [Current Quantity]) , [Current Quantity])
    Difference % = divide([Quantity Last Period] , [Current Quantity]) -1

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous 

One if the two


Difference % = divide([Quantity Last Period] - [Current Quantity]) , [Current Quantity])
Difference % = divide([Quantity Last Period] , [Current Quantity]) -1