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 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
IDEA is a trademark of CaseWare International Inc., used by permission.
All material provided on the IDEAScripting website is presented as is without any warranty or guarantee. Anybody using any solution provided on this pages is encouraged to validate the effectiveness and reliability on their own.
IDEA Help Videos
IDEA Related Videos
IDEA Success Stories