This is one of those tricky sorting thingies.
You can have another field for the sort that isn't even shown on the layout.
If ( <<your calc field here>> = 0 ; 6,000,000 // or something ridiculously large
; <<your calc field here >> )
Sort on that field.
Ha - Love it! Tricky sort thingies...
Although yes, the solution will work (no chance of any big numbers in the 'Money' field!)
Thanks for that Beverly
The list function or Summary field List of will not return empty fields. If the list is sorted in ascending order, the first value in the returned list should be the value that you are looking to get.
You can reduce the calc down to a simple IsEmpty(MoneyAdj). This will return a 1 if empty or a 0 is not empty. then Sort on this field in ascending order and then the MoneyAdj field in ascending.
so true for a multi-field sort!!