Sort numerics without NULLs

Mees · January 26, 2011 3:29AM

Hi there, I need to sort ascending a numeric column. null values are sorted before zero or one.
Can I change this somewhere in the settings, so that null values are sorted at the end?
Thanks

steve · January 26, 2011 4:03AM

Not currently. Please edit or repost this in Ideas, and vote on it.

To work around this, you need to add a formula field which is used to provide the custom order - something like this:
IF([field]=null, 10000000000, [field])
You will need this field to be showing, though it can be very narrow, and sort on it.

Welcome!

Categories

Ideas Parade