Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm currently using this formula to rank counts.
=rank(count(FacilityAccountID),0,1)
However, I'm getting the result below.
How do I break the ties in the Rank number column? Is there another field that can be used to break the tie?
Thanks!
Try this may be:
=Num(Rank(Count(FacilityAccountID),4,1))
Thank you so much for your help!!!!!!!