5 Replies Latest reply on Mar 20, 2014 7:51 AM by MichaelShearer

    Multi criteria sort

    MichaelShearer

      Title

      Multi criteria sort

      Post

           I'm trying to script a sort that sorts by two fields, "Week's Total" and "Score". "Week's Total" is easy, sort by the highest number. The second is a little harder. The "Actual Score" may not match the score picked. I will need it to be the closest to the actual score. It can be over or under but it has to be the closest.

           Here is an example:

           I have picked 11 correct and score of 30. You pick 11 correct and a score of 40. The actual score is 33. I'm 3 off but you are 7 off so it sorts me #1 and you #2.

           I'm also trying to find the sort order list. The help mentions it but I haven't located it.

           Thx

           Mike