Forum Discussion
Dealing with Null Values
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?
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
3 Replies
Is there a reason you need to chande the null value to blank? Null values are blank by default once loaded
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
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..
