Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Add Datefield also.
Date = {'<$(=Today())'}
Thanks! That did it.
Jennie