Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
DKK
Contributor III
Contributor III

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

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

KD

Labels (2)
2 Replies
sugathirajkumar
Creator
Creator

rank(sum(Amount))

clipboard_image_0.png

DKK
Contributor III
Contributor III
Author

Hi,

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