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?
YTD will be a Running_sum() calculation. is there a reason that you do not just create a new calculation for Running total?