How to give two conditions for same field in set analysis?

[#1]

Hi,

Below is my original set expression:

=sum({<Year={$(vPriorYear)}, TRANSACTION_DATE={'>=$(=YearStart(max(TRANSACTION_DATE),-1))<=$(=AddYears(max(TRANSACTION_DATE),-1))' }>} NTPV_AMT)

Now I want to add one more condition on TRANSACTION_DATE,

TRANSACTION_DATE={'>=$(=Date(date(max(TRANSACTION_DATE)-(vDays))))<=$(max(TRANSACTION_DATE))'}

I tried doing it with AND but it didn't work.

=sum({<Year={$(vPriorYear)}, TRANSACTION_DATE={'>=$(=YearStart(max(TRANSACTION_DATE),-1))<=$(=AddYears(max(TRANSACTION_DATE),-1))'  AND

'>=$(=Date(date(max(TRANSACTION_DATE)-(vDays))))<=$(max(TRANSACTION_DATE))'

}>} NTPV_AMT)

Any suggestions or help on how to achieve it.

--Sachin

[#2]

Hi

I changes my expression to

=Sum({<Year={$(vPriorYear)}, TRANSACTION_DATE={'>$(=Date(AddYears(Max(TRANSACTION_DATE), -1)-vDays))<=$(=AddYears(max(TRANSACTION_DATE), -1))'}

>}NTPV_AMT)

And it worked..

Thanks though.

[#3]

Hi Stefan,

I changes my expression to

=Sum({<Year={$(vPriorYear)}, TRANSACTION_DATE={'>$(=Date(AddYears(Max(TRANSACTION_DATE), -1)-vDays))<=$(=AddYears(max(TRANSACTION_DATE), -1))'}

>}NTPV_AMT)

And it worked..

Thanks though.

[#4]

you have to Try adding a new field in the script ..with max TRANSACTION DATE YYYY-MM-DD range 2015-05-21 to 2015-07-31

and https://goo.gl/fJU04B