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.
Starbiscuit
Offline
Last seen: 2 years 10 months ago
Joined: 05/07/2021 - 17:43
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