Set Analysis with Variables

[pkelly]

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

[Miguel_Angel_Baeyens · Accepted solution]

The syntax should be like

{< soi_LatestDate = {">=$(varTomorrow)"} >}

Or even if you need to expand further

{< soi_LatestDate = {">=$(=varTomorrow)"} >}

[pkelly]

Thanks Miguel...ended up with the following

soi_LatestDate = {">$(=varTomorrow)"}