What is the best way to handle NULL values when it comes to Date and Numeric fields?

[jblomqvist]

Hello,

I have a series of tables where we have lots of null values in various fields.

In Dimension type fields it is easy to set them to "Unknown" etc.

What is the best way to handle NULL values when it comes to Date and Numeric fields? If I also set both of these types of fields to replace Null with "Not known" - is that problematic? Is it poor practise?

What is a good alternative for null values for Date and Numeric type fields?

[YoussefBelloum]

Hi,

a lot of experts here use this:

len(trim(FIELD))=0

this will handle NULL and EMPTY cells and also replace the Isnull() function

give it a try

=if(len(trim(FIELD))=0;'NULL', FIELD) as FIELD