Scenario:
A Saved Search has more than one Formula field of the same type (eg. Numeric, Text, etc). Users are limited to sorting the result using the first Formula field on the Results tab. Clicking the next Formula field/s does not allow sorting.
Solution:
This is currently a limitation in Netsuite. When using more than one Formula field of the same data type, users may only sort the first one.
To resolve this, please change the data type.
eg. There are two Formula (Numeric) fields but only the first one can be sorted.
Instead of using Formula (Numeric) for the second field, change it to Formula (Currency). This will allow to sort both fields.