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

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago
So like:

Percent Difference = ([Quantity Last Period] - [Current Quantity]) / [Current Quantity]

?