I created a custom field in the query designer with the name of 1 and an alias of UgStudent. In the field settings properties I chose View as Custom and added my code. Now when viewing the list on the web. The UgStudent has correct value but when I click the sorting header it is not giving me the correct sorting of numbers. Can someone tell me how to address this. Thanks
Data can be only sorted by what's in the database. If you apply 'View as' Custom and change the way data is display you cannot use those computed values to sort your data.