Set Analysis with Variables

pkelly — Mon, 11 Sep 2017 10:00:55 GMT

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

Re: Set Analysis with Variables

Miguel_Angel_Baeyens — Mon, 11 Sep 2017 10:04:03 GMT

The syntax should be like

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

Or even if you need to expand further

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

pkelly — Mon, 11 Sep 2017 10:37:39 GMT

Thanks Miguel...ended up with the following

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