Set analysis expression

[#1]

Hi,

Could anyone help me with this expression:

(

sum ({$<REDEMPTION_DATE={'=6/1/2012'},

GC_BUY_OR_REDEEM_R-={'B'}

>} REDEMPTION_AMOUNT))  is showing values though the REDEMPTION_DATE='06/09/2012' original expression is

(

sum ({$<REDEMPTION_DATE={'=$(=Date(VREDMPTION_DATE))'},

GC_BUY_OR_REDEEM_R-={'B'}

>} REDEMPTION_AMOUNT))

Pls help.

Thanks,

Swetha

[CELAMBARASAN]

Hi,

sum ({$<REDEMPTION_DATE={'6/1/2012'},

GC_BUY_OR_REDEEM_R-={'B'}

>} REDEMPTION_AMOUNT)

Whats the issue in this expression you didnt mention anything about that?

Celambarasan

[#3]

Even though I need the data for only Redemption_date of 06/01/2012 its showing data for other dates too the filter of REDEMPTION_DATE is not working.

[CELAMBARASAN]

Hi,

     If You assign hard code value for Redemption Date in set analysis then filter won't work.

[#5]

I did nt assign a hard code value my original expression is

(

sum ({$<REDEMPTION_DATE={'=$(=Date(VREDMPTION_DATE))'},

GC_BUY_OR_REDEEM_R-={'B'}

>} REDEMPTION_AMOUNT))

and I have the VREDEMPTION_DATE as '06/01/2012'  but its still showing values for REDEMPTION_DATE as '06/09/2012.

[CELAMBARASAN]

Can you attach a sample app?