Skip to main content

Rank

Hi.  Is it possible to rank numeric results similar to the rank function in excel e.g
 55,767,767,825 would be 1,2,2,3.

klmi Mon, 05/10/2021 - 09:41

A special @RANK function doesn't exist.
But it's possible to do that in IDEA as follows:
1) do a summary by the field with the numbers you want to rank
2) add a new field with @RECNO() function
3) join both databases