1 Reply Latest reply: Oct 2, 2018 9:45 AM by Dilip Ranjith RSS

    calculating Year on Year % increase when master calendar is used

    Mallika Mhapankar


      I am trying to get the YoY % increase from A to B. however the set analysis i am using is somehow returning inflated percentages.

      A= sum({$<CFYTDFlag={1}>}PartCost



      where CFYTD is the current sales and LYFTD is the previous year in the master calendar.

      and these two are master dimensions.

      I now want the YoY % increase from LFYTD to CFYTD.



      I tried




      but this is giving me the % above 100%.

      Can someone tell me how I can get the year on year increase?