Dealing with Null Values

[jp25]

Hello, 

I have the following table. In the income column, that has several 'NULL' values.

My first thought was to replace it with a blank, that I am unable to do. I tried replacing 'NULL' with 'NOT AVAILABLE', that too was not possible as the column is set to 'whole number' type. 

Can you please suggest what's the best way to deal with this scenario?

[manikumar34 · Accepted solution]

@jp25 , 

NULL values will be reflected as blanks on the report, no need to make any change. 

If you want to do, you make it to zero. Replacing with 'NULL' or 'NA' or any string value then you have to  make your column to TEXT type. 

Regards, 

Manikumar

[jp25]

@manikumar34 . Thank you. I was a bit confused. I think I will change it to a zero. So I don't get an error in the case, I use this column as a measure, so, for example, average income etc.. 

[PaulDBrown]

@jp25 

Is there a reason you need to chande the null value to blank? Null values are blank by default once loaded