Issue in Aggr Rank fn in set anlysis

[#1]

Hi swuehl‌ maxgro‌ sunindia‌ RamonCova06‌

Even though I have given 1 in my set analysis to exclude current selection, still it's getting applied to my Aggr Rank expression. How do I handle this issue?

[sunny_talwar]

You need {1} a lot of the other places.Try this:

Rank(Only({1}Aggr(

Sum({1< [Transaction ID] -= {$(vTransactionIDsToExclude)}, $(vSecFilter)>+<[Transaction ID] = {$(vTransactionIDsToInclude)}>} [SEC Amort Discounted Balance])

+

Sum({1<[Active Flag] = {'Active'}>}, [Portfolio Code] = {'1'}, Company Code = {'1'}, [Region Code] = {'60'}>}[SEC Amort Discounted Balance]),

Customer Name)))

Not sure how you define your variables vTransactionIDsToExclude, vSecFilter and vTransactionIDsToInclude

[#3]

Sunny, Thank you it worked..

[sunny_talwar · Accepted solution]

Awesome

I am glad it worked. Would you mind closing this thread by marking the correct answer.

Best,

Sunny