Rank list of numbers
Is there a way to determine the rank of a number in a list without using the RANK functionality in BEX? I need a final result of whole numbers like 1,3,4,5,6, etc.
We need to do this because the number generated by the RANK functionality in BEX is not available for subsequent use in further calculations. could this be done somehow using the sum of the list and maybe the count of items?