topic Re: Creating Ranks in script for tied values and then skipping the next rank by Autonumber in App Development

Creating Ranks in script for tied values and then skipping the next rank by Autonumber

DKK — Sat, 16 Nov 2024 20:07:48 GMT

Hi All

I was trying to creating the ranks for the following data as follows but some how its not giving the right results by using Autonumber function. output required for ranks should be something like ( 1,2,2,4,5,6,6,8) and attached is the excel file for reference. Any advise or help is highly appreciated

Regards

Re: Creating Ranks in script for tied values and then skipping the next rank by Autonumber

sugathirajkumar — Fri, 06 Sep 2019 06:45:29 GMT

rank(sum(Amount))

Re: Creating Ranks in script for tied values and then skipping the next rank by Autonumber

DKK — Fri, 06 Sep 2019 10:04:14 GMT

Hi,

i don’t think we can use Rank() function in the script . Moreover my desired rank should be something liken1,2,2,4