Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
=Sum({<soi_RevisionDate ={"$(=varToday)"}, soi_HistoricalMonthNumber_Latest = {0}, soi_LatestDate = {"$(=varTomorrow)"}>} soi_Sales)
I have the above Set Analysis statement which I am using in a Pivot Table.
soi_RevisionDate is the day the orders was keyed
soi_HistoricalMonthNumber_Latest is the month in which the order is due with 0 = current month
soi_LatestDate is the latest date the order is due to the customer
varToday = todays date
varTomorrow = tomorrows date
What I am trying to do is show orders keyed today which are due this month but greater than tomorrow
The statement I have show will only give orders keyed today which are due tomorrow - how do I make this greater than tomorrow?
Thanks in advance for any assistance given.
Paul
The syntax should be like
{< soi_LatestDate = {">=$(varTomorrow)"} >}
Or even if you need to expand further
{< soi_LatestDate = {">=$(=varTomorrow)"} >}
The syntax should be like
{< soi_LatestDate = {">=$(varTomorrow)"} >}
Or even if you need to expand further
{< soi_LatestDate = {">=$(=varTomorrow)"} >}
Thanks Miguel...ended up with the following
soi_LatestDate = {">$(=varTomorrow)"}