Set analysis help rank()

[alexpanjhc]

i was inspired by one of the threads, and i came up with the following, but get an error:

Error in set modifier ad hoc element list: ',' or ')' expected

only({<[Cat]={"=Rank(max(Aggr($(vCoalitionView_ Size) , [Cat]))) =1"}>}Price)

I tested that this is correct without error   :max(Aggr($(vCoalitionView_ Size) , [Cat])) 

please help!

[sbaro_bd]

Hi @alexpanjhc ,

And when you try it with the rank function (Rank(max(Aggr($(vCoalitionView_ Size) , [Cat])))), it works?

Regards.

[alexpanjhc]

@sbaro_bd 

yes, that worked too! the rank is 1, which is what I expected.

[JGMDataAnalysis]

In the definition of the vCoalitionView_ Size variable, do you use double quotes?

[alexpanjhc]

@JGMDataAnalysis 

yes double quote was used too, you mean this?

sum(DISTINCT{<[-TimeKey]={"$(=$(=vWalletMaxYear))"}>} (Wallet*1000000) 

[JGMDataAnalysis · Accepted solution]

Yes, try replacing with single quotes.

[JGMDataAnalysis]

I'm assuming that the vWalletMaxYear variable does not involve double quotes.

[alexpanjhc]

@JGMDataAnalysis  genius, thank you!