1 Reply Latest reply on Aug 9, 2017 10:56 AM by Patrick A Van Der Hyde

    Converting YoY Quick Calculation to YTD Growth calculation manually

    Jana STUPAVSKY

      I have this YoY Quick Calculation formula: (ZN(SUM([c.Airport Pax Total])) - LOOKUP(ZN(SUM([c.Airport Pax Total])), -1)) / ABS(LOOKUP(ZN(SUM([c.Airport Pax Total])), -1)) and I need to convert it into YTD Growth calculation. The problem seems to be the fact that there is a primary calculation within this YoY calculation, therefore I am unable to "Edit in Shelf" and simply copy and paste the actual formula. Can someone help me convert this one to reflect YTD Growth?