Rank

2 posts / 0 new
Last post
Starbiscuit
Offline
Joined: 05/07/2021 - 17:43
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
Offline
Joined: 02/13/2019 - 08: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