Starbiscuit Fri, 05/07/2021 - 18:28 Forums Questions on IDEA Analysis 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. A special @RANK function 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 Log in or register to post comments Log in or register to post comments
A special @RANK function 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 Log in or register to post comments
A special @RANK function
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