Issue in set anlaysis exclude expression

[#1]

Hi,

Below is my set analysis expression which works perfectly fine.

[Disc. Bal.]

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

} TOTAL( [SEC Amort Discounted Balance]))

But I now have a new requirement to exclude current selection. So I added '1' but now I'm getting very wierd results. Can anyone explain me the issue in my expression

[Disc. Bal.]

/
SUM({< [Transaction ID]-={$(vTransactionIDsToExclude)}
,  $(vSecFilter)
>
+
<[Transaction ID]={$(vTransactionIDtoInclude)}>} TOTAL( [SEC Amort Discounted Balance]))

+
sum({1 <   [Active Flag] = {'Active'}
  ,  [Portfolio Code]={'1'}
  ,  [Company Code]={'1'}
  ,  [Region Code]={'60'}>

} TOTAL( [SEC Amort Discounted Balance]))

Regards,

Sachin

[marcus_sommer]

You could try it with 1- or you extend your set analysis statement to some E() functions:

{< Dimension = e(Dimension) >}

- Marcus