2 Replies Latest reply: Feb 13, 2014 10:48 AM by Jennie Elliott RSS

    Show data through yesterday

    Jennie Elliott

      I have one sheet in my app that I want to show data through yesterday only. I am displaying data for this week but DO NOT want to include today's data.

       

      My formula is as follows:

      ({1<CurrentPeriodWeek={1}, INV|VoidFlag-={Y}, DB|Source={'TP'}, LOC|CorpFlag={0}, TP|StoreNumber-={1,9}, INV|TransTypeID={1,17}>}TS|GrossRev)

       

      Suggestions?

       

      Thanks