2 Replies Latest reply on Aug 20, 2018 10:24 AM by Deepak Rai

    Calculating Month over Month Ratio every 6 months

    malvika.tripathi.0

      I have fields called Months and Value. Months is actually a discrete dimension and is plotted as 0 to 20 on the x axis. Percentage value is on the y axis. I want to create a calculated field for a month-over-month ratio for every 6 months. So the first calculation will be (Month 7)/(Month 6), next it should show a drop in (month 13)/(month 12) and so on. I tried using LOOKUP([Value], 8)/LOOKUP([Value], 7) but it seems to be returning incorrect values. Any help will be appreciated. Note: month is plotted as dimension.

       

       

       

      Monthsvalue
      194.06%
      292.00%
      387.88%
      485.29%
      582.95%
      681.66%
      777.12%
      876.08%
      974.98%
      1073.79%
      1172.63%
      1271.99%
      1366.37%
      1465.50%
      1564.66%
      1663.83%
      1763.23%
      1862.85%
      1960.35%
      2059.83%