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
