Problem with set analysis- exclude

[#1]

Hi sunindia maxgro swuehl RamonCova06,

This is my expression:

SUM({<[Transaction ID]-={$(vTransactionIDsToExclude)}, $(vSecFilter)>
+
<[Transaction ID]={$(vTransactionIDtoInclude)}>}[SEC Amort Discounted Balance] )
+
sum({1<   [Active Flag] = {'Active'}
,  [Portfolio Code]={'1'}
,  [Company Code]={'1'}
,  [Region Code]={'60'}
,  [SEC Amort Discounted Balance]={'>0'}
>}[SEC Amort Discounted Balance] )

It just works fine.

But when I just add one condition i.e., [RAL State] = {'TX'}. And exclude TX from my current selection, its not excluding TX in my expression.

SUM({<[Transaction ID]-={$(vTransactionIDsToExclude)}, $(vSecFilter),[RAL State]={'TX'}>
+
<[Transaction ID]={$(vTransactionIDtoInclude)},[RAL State]={'TX'}>}[SEC Amort Discounted Balance] )
+
sum({1< [Active Flag] = {'Active'}
,  [Portfolio Code]={'1'}
,  [Company Code]={'1'}
,  [Region Code]={'60'}
,  [SEC Amort Discounted Balance]={'>0'}
,   [RAL State]={'TX'}
>}[SEC Amort Discounted Balance] )

Thanks in advance.

Regards,

Sachin

[sunny_talwar]

You want to exclude TX or include it from your selection?

[#3]

Sorry, just include.

[#4]

Sorry for the confusion Sunny.

I'm selecting TX in my set analysis but excluding it in my current selection.

[ramoncova06]

you have two expressions what happens when you separate them, you are defining them as part of your set analysis so they will always show