2 Replies Latest reply: Feb 17, 2014 12:23 AM by jagan mohan rao appala RSS

    today - 4 of last year? how?

    ben lim

      Hi guys,

       

      I have this code

      =round((sum({<Month_Id={"$(=max({<Month=>} Month_Id))"},Date ={'<=$(=Date(today()-4))'}>} TEU

       

      This code will find the value(TEU) of current month on today - 4. Example saying today is 17th of feb, it will find the value on 13th of feb 2014

       

      Now I would want to find 13th of feb 2013 so that I am able to find whether is it growth or decline in year on year comparison.

       

      is there anyway that i am able to code? thanks