Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i was inspired by one of the threads, and i came up with the following, but get an error:
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!
Yes, try replacing with single quotes.
Hi @alexpanjhc ,
And when you try it with the rank function (Rank(max(Aggr($(vCoalitionView_ Size) , [Cat])))), it works?
Regards.
yes, that worked too! the rank is 1, which is what I expected.
In the definition of the vCoalitionView_ Size variable, do you use double quotes?
yes double quote was used too, you mean this?
sum(DISTINCT{<[-TimeKey]={"$(=$(=vWalletMaxYear))"}>} (Wallet*1000000)
Yes, try replacing with single quotes.
I'm assuming that the vWalletMaxYear variable does not involve double quotes.
@JGMDataAnalysis genius, thank you!