How to display Null value first and then descending display in table field?

[melodyxu]

I edit sheet to add a expression in sorting for date field sorting.

In this date field soring, Null value first need display on the top and then others descending displays.

And I try to use these expression, but failed.

If( IsNull([datefield]), 1, 0) & '-' & -[datefield]

If(IsNull(datefield]), date(now()), [datefield])

what should I do? 

[Oleg_Troyansky]

Hi,

I think the problem is that you are using the NULL value in your expression - any operations with NULL will results in NULL. Here is what I'd recommend:

IF( IsNull(DateField), DUAL('-', 0), DateField)

This formula should replace NULL values with dual values that will get sorted before any non-null values.

There might be another hidden issue. Sometimes, depending on the data structure, you may see something that appears as a NULL value, but instead it's a "missing value" - that value doesn't exist, based on the way different data elements are associated. In that case, this formula won't help because DateField is not NULL, but it's rather missing at all.

Hope it helps, cheers!