5 Replies Latest reply: Mar 23, 2015 5:10 PM by Krishan Patel RSS

    Get a value one year back based on the current value

    Krishan Patel

      Current date = 201503

      I am trying to get the Bonus Amt and MM one year back based on the current date. I tried the formula below but its not working.

       

      =sum({$<Month= ,YEAR= ,Rolling12= ,QUARTER= ,DateofService=AddMonths(DATE,-12)>}Bonus_Amt)
      /
      =sum({$<Month= ,YEAR= ,Rolling12= ,QUARTER= ,DateofService=AddMonths(DATE,-12)>}MM)

       

      Thanks