0 Replies Latest reply: Oct 1, 2018 5:15 PM by Mallika Mhapankar RSS

    calculating % 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?