Rank in reverse order

Tue, 06 May 2014 15:10:49 GMT

Hi,

I wanna find the min and max value of a line graph. I have founded a way to do so. But im not able to reverse my rank

If i rank my expression i get the min value as Rank 50 and max Value as Rank 1.

Now i wanna new expression which ranks the other way, so i rank my Min value as 1 or -1 and max value as 50 or -50.

Can anyone help?

Thanks

Re: Rank in reverse order

swuehl — Tue, 06 May 2014 15:35:42 GMT

If you ranked like

=rank(sum(Value))

then try

=rank(-sum(Value))

so the min of sum(Value) should be ranked 1.