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
Is there a reason you need to chande the null value to blank? Null values are blank by default once loaded