8 Replies Latest reply: Feb 19, 2014 12:48 PM by Jennie Elliott RSS

    Show data from date range of previous year

    Jennie Elliott

      When someone enters in a specific date range from this year in an input box, I would like it to show gross revenue from the same dates of the previous year. My last year expression is as follows. How can I accomplish this?

       

      So if I select 2/2/2014 through 2/15/2014, I want the corresponding dates from 2013 for Gross Revenue

       

      ({$<DB|Source={TP}, INV|VoidFlag-={Y}, TP|StoreNumber-={1,9}, Year={$(=max(Year)-1)}, INV|TransTypeID={1,17}>}TS|GrossRev)