Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=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.
Thumsup
To closed this thread you have to make it either correct or helpful because it might be helpful for other users
Regards
Mohit
Try: if(EVT_DATE EVT_DATE <=date#('4/1/2013','M/D/YYYY') or >= date#('4/30/2013','M/D/YYY') ,PROGRAM_ID)
thanks for the reply Gysbert Wassenaar, but i am not able to filter the data its giving all program id s
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
this expression looks good, but giving error near that -=
thnaks man er.mohit ur expression is working insted of sum i took count its working thnaks a lot .
Thumsup
To closed this thread you have to make it either correct or helpful because it might be helpful for other users
Regards
Mohit