Ranking based on deviation from zero

[#1]

Dear Experts,

We are having a business requirement where we want to rank the values based on deviation from zero.

the value which is having lowest positive difference from zero will get the rank 1.

Next postitive deviation will get rank 2. Then lowest negative difference will get rank 3 and so on.

For Example

Percentage	Rank
10	2
5	1
-2	3
-5	4

A quick response will be appreciated.

Regards,

Prashant Karanjgaonkar

[Chanty4u]

try

=Firstsortedvalue(percentage,Field)

[#3]

Hi,

thanks for quick reply.

Can you help with a test application.

[Chanty4u]

simple example read below

FirstSortedValue()

[techvarun]

May be use a hidden expression like below

If(Percentage> 0,100- Percentage, Percentage -100)

and try Rank(Column(1)) as the actual rank expression

[#6 · Accepted solution]

Hi

Please use following expression

Rank((vMaxValue-VALUE)*(if(VALUE>=0,1,-1)))

[#7]

Rank((vMaxValue-VALUE)*(if(VALUE>=0,1,-1)))

[pathiqvd]

Hi,

Try this you will get solution,

=aggr(rank(if(Percentage>0,$(=max(Percentage))-Percentage,Percentage-$(=max(Percentage)))),Percentage)

Regards,

[#9]

superbbbbbbbb Amit Dubey.

Also thanks to  Prashant ,for such type of problem statement

Amit dubey ,can provide one test application for this,if yes it is very helpful.