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

    calculating % increase when master calendar is used

    Mallika Mhapankar

      Hi,

      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

      B=sum({$<LFYTDFlag={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

      ((sum({$<CFYTDFlag={1}>}PartCost)-sum({$<LFYTDFlag={1}>}PartCost))

      /(sum({$<LFYTDFlag={1}>}PartCost)))*100

       

      but this is giving me the % above 100%.

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

      Thanks