21 Replies Latest reply: Sep 28, 2015 5:59 PM by RSS

    YoY and MoM % Growth

      Hi,

       

      I am trying to calculate YoY Income Growth 2015-2014 and MoM Volume Growth May 2015-May 2014 but am unable to get the calculation right.

      This is my month Calc to bring in volume

      Sum({$<Year={ $(=max(Year)) }>} [PIP_Profit_or_Loss])+ Sum({$<Year={ $(=max(Year)) }>} [Commission_Amount])

       

      This is my month Calc to bring in volume

      sum ({<[Month-Year] = {">=1<=5"}, [Month-Year] = {'Mar-2014','Mar-2015'}, Date =, Week=>} Volume)

       

      Please be so kind as to assist me.