The Only Sort Order List is the the dialog box that opens when you select Sort From the Records menu.
How is this data set up in your records? It appears that "Score" is not a value in the same table or a value in a global variable or field. These details are needed in order to produce the results that you want--which will use a calculation field to compute the difference between the predicted and actual scores.
I have the "actual score" as a global and the "Submitted score" as a number. They are all on the same table/layout.
I was thinking the same way as you. But with the Submitted score being either more or less than the actual score I think I may need to go with absolute values.
Exactly, you take the absolute value of the difference between the two fields and then you have a field on which you can sort and/or search. It will be an unstored field, which is slower than a stored/indexed field for searching and sorting, but it will work.
Abs ( Score - ActualScore )
I'll give it a try tomorrow afternoon.
I'll let you know.
Got it Phil.