1 Reply Latest reply on Oct 11, 2019 12:06 AM by shuhei saito

    Calculating MOM % Difference change

    Nikhil Parmar

      Looking for some assistance in calculating the % difference change in values

       

      Based on the screenshot I am able to get the % difference using the built in calculation and also get the difference from the previous month. What i am struggling with is getting the difference in % values.

       

      I.e if for the month of June 2018 my % value is 1.2% and July is -7.8% i would like to see the difference between the 2 values i.e. -6.6%

       

      Also what would be a bonus would be to see it a KPI number for a month ( where the month will be a parameter that the user selects )

       

      Thank you in advance