Forum Discussion
Solved
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 '...
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 ,
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..