topic Re: Rank basis on Absolute value but display Positive/Negative number in table in App Development

Rank basis on Absolute value but display Positive/Negative number in table

Saurabh07 — Mon, 20 Dec 2021 21:08:46 GMT

Hello Gurus,

I have mentioned dataset:

Country	Value
India	-7854
Japan	-7662
Korea	6589
China	6541
Germany	-6102
France	5028
Italy	4036
Australia	3521
Netherlands	-2258
Denmark	1975

I want to pick Top 5 countries on basis of highest value. But my condition is, the ranking should be done considering the absolute value but while displaying the value in table it should display the original (positive/negative) number.

Any help on this requirement would be highly appreciated!

Re: Rank basis on Absolute value but display Positive/Negative number in table

MayilVahanan — Mon, 30 Nov 2020 05:53:24 GMT

HI @Saurabh07

May be try like below

Dim:

=Aggr(If(Rank((if(Sum(Value)<0, Sum(Value)*-1, Sum(Value))))<=5, Country),Country)

Measure1: Sum(Value)

Measure2: Rank((if(Sum(Value)<0, Sum(Value)*-1, Sum(Value))))

Re: Rank basis on Absolute value but display Positive/Negative number in table

Saurabh07 — Mon, 07 Dec 2020 14:03:37 GMT

@MayilVahanan this worked, thank you so much!!!!

Re: Rank basis on Absolute value but display Positive/Negative number in table

Akbar — Wed, 05 Oct 2022 12:12:45 GMT

thank you 🙂