Is it possible to have a related list sorted by a specific column while displaying the empty values last? By default, these are shown at the top of the list.
The field i want to sort after has the type
Number(13,5), let's call it
FieldToSortAfter__c. In SOQL i can do:
SELECT Field1__c, Field2__c FROM MyObject__c ORDER BY FieldToSortAfter__c NULLS LAST
I didn't find a counterpart for sorting related lists, though. I have already tried creating a formula field
Order__c with this content:
IF( ISNULL(FieldToSortAfter__c),( 9999999999999.99999 ),( FieldToSortAfter__c ))
But when i want to use this to sort the related list, i have to display the column which looks ugly. Any suggestions on how to improve this?