AnsweredAssumed Answered

Sort blanks last

Question asked by AllegroDataSolutions on Dec 20, 2013
Latest reply on Dec 20, 2013 by erolst

I have a portal that is sorted by a value in a global field. User selects from a value list in the field used to sort the portal:


Priority

Completed

Date

Event Name

 

If "Priority" is selected, a formula gets the value of a field which may contain a numeric value from 1 to 9.
If "Completed" is selected, a formula gets the value of a field which may contain a numeric value of 1.

If "Date" is selected, a formula gets the numeric value of a field containing a date.

If "Event Name" is selected, a formula gets the value of a field containing text.

 

Any of the fields referenced in the formula may have been left blank.

The calculation returns the resut as text.

 

It all works fine -- except that, when the list is sorted in ascending order, records in which the selected sort field is empty sort at the top of the list. For example, if sorted by Priority, all the records with no value for priority appear in the top rows of the portal and the user has to scroll down to see all those with a priority of 1, followed by those with a priority of 2, and so on.

 

If I sort in descending order, the Event Name field sorts in reverse alphabetical order -- which, obviously, we do not want.

 

I am looking for the simplest way to correct this last problem.

 

Thanks.

Outcomes