0 Replies Latest reply: Jul 1, 2010 10:25 AM by Les Backman RSS

    MTD CALCULATIONS, PLEASE HELP

       

       

      Hi,

      I am trying to calculate comparative MTD values for our GP but I have to offset previous years by one day...this is what I have but it doesn't seem to be working like I want....this is for 2008

      sum

       

       

      (if(YearToDate([INVC DATE],-2,month(today()),(today()-1)),[TOT REG $GP]))