topic Re: SET ANALYSIS yesterday sales with selected day in App Development

SET ANALYSIS yesterday sales with selected day

m_alsoby — Mon, 16 Jan 2017 12:32:24 GMT

Gents,

Greetings,

Looking to use Set Analysis to have a dynamic variable for date field to retrieve yesterday [of the selected day] sales.

my Fields are :

1- TRANSACTION_DATE (For Date)

2- SALES (For Sales)

and I use IF condition for retrieve a specific category of sales already do it.

I tried many statements some them gave Zero values and some Gave me -

Sum({$<TRANSACTION_DATE={'MAX(TRANSACTION_DATE) -1'}>}SALES)

Sum({TRANSACTION_DATE={"$(vToDate)"}} SALES

kindly help me to find the Solution for that

Re: SET ANALYSIS yesterday sales with selected day

lironbaram — Mon, 16 Jan 2017 12:37:08 GMT

try this

Sum({$<TRANSACTION_DATE={'$(=MAX(TRANSACTION_DATE) -1)'}>}SALES)

if this doesn't work

try this , it's important that you'll use exactly the same date format as TRANSACTION_DATE format

Sum({$<TRANSACTION_DATE={'$(=date(MAX(TRANSACTION_DATE) -1,'DD/MM/YYYY'))'}>}SALES)

Re: SET ANALYSIS yesterday sales with selected day

MK_QSL — Mon, 16 Jan 2017 12:42:41 GMT

SUM({<TRANSACTION_DATE = {'$(=Date(Max(TRANSACTION_DATE)))'}>}SALES)

and

SUM({<TRANSACTION_DATE = {'$(=Date(Max(TRANSACTION_DATE)-1))'}>}SALES)

Re: SET ANALYSIS yesterday sales with selected day

m_alsoby — Mon, 16 Jan 2017 13:26:49 GMT

thanks Dears lironbaram‌‌ and Manish,

both of your suggestions are working probably without select a specific date but once i select a date the value will be Zero and I'm sure this field contain value and absolutely not zero

any suggestions from your End about this issue ?

Re: SET ANALYSIS yesterday sales with selected day

m_alsoby — Mon, 16 Jan 2017 13:39:30 GMT

thanks a lot dear i got it now this issue has been solved

appreciate you help