Help with a script
For each record, I have a field called Place and a field called Total.
The Total field is sorted by Ascending order, and the Place field is a result of the sort order. Ex:
If the Total fields are all different it is simple to create the Place field. I simply use "Replace by Serial." BUT, if some of the Total fields happen to be the same, then the Place results need to be quite different. Ex:
For both of these examples, the starting number is always a 1 or if a tie, 1T and the final number is equal to the total number of records - unless - in a very rare instance - all the Totals would happen to be the same. In this instance, the result would be. Ex: (Example two is the most normal of all scenarios.)
Does anyone have any idea what a script would look like to accomplish this? If this looks familiar, I posted this a while back, but the script I ended up with did not work.