5 Replies Latest reply: Jun 18, 2010 4:03 PM by Fernando Toledo RSS

    Offsetting Dates

      I am trying to do a comparison of this year sales to last year sales, YTD,

      My data however gets generated over night to include up to the previous days sales.

      So if comparing to last year to date, I have to offset the results by one day. I came up with this expression but I am convinced it is not right,

      sum(if(yeartodate([INVC DATE]-1,-1), [TOT SALES])

       

      What do you think?