Not able to filter the data

[#1]

=if(PROGRAM_ID <> if(EVT_DATE <= '4/30/2013' and EVT_DATE >='4/1/2013',PROGRAM_ID),PROGRAM_ID)

in the above expression i want to filter the program id where transaction has not taken place in last month.. please someone help its urgent.

[Gysbert_Wassenaar]

Try: if(EVT_DATE EVT_DATE <=date#('4/1/2013','M/D/YYYY') or >= date#('4/30/2013','M/D/YYY') ,PROGRAM_ID)

[#3]

thanks for the reply Gysbert Wassenaar, but i am not able to filter the data its giving all program id s

[er_mohit]

Try this

sum(PROGRAM_ID -= P({<EVT_DATE ={">=4/1/2013 <=4/30/2013"}>}PROGRAM_ID)>}PROGRAM_ID)

its not giving error you jst check ur expression is ok

because we use in set analysis -= then it show under line not error

by my mistake i don't write that

{<

acc . to vishwaranjan so please you ll write that so that, vishwaranjan will be happy to see this syntax actully works

[#5]

this expression looks good, but giving error near that -=

[#6]

thnaks man er.mohit ur expression is working insted of sum i took count its working thnaks a lot .

[er_mohit · Accepted solution]

Thumsup

To closed this thread you have to make it either correct or helpful because it might be helpful for other users

Regards

Mohit