2 of 2 people found this helpful
Right click on the "Category ID" column convert it from discrete to continuous. Then again select the column select " Format"
Under "Pane" section you will find special values
Type the text on the blank space (Ex.8 as you requested).
Then you can able to show the value "8" on all black places on text report.
For discrete values you have to make change in the data source.
If the above suggestion (which is a good one) doesn't work the calculated field option may work for you, using an IFNULL([Category Id],8) formula.
Thanks for your help. But i am wondering if doing so, all the null value will be replaced with 8, however, for id 18562852, it should be replaced with 1. I have multiple ids have this issue. So I just want to get a logic works : if it is null, then replace by a value which it has (under below).
Do you have any idea on this?
Welcome. I don't think we may have such a direct method based on a column we can specify default values. But before confirmation we should try some workaround to achieve it, let's try it. Meanwhile take a look into solving those problems on source data itself.
Please provide sample data AND the business logic behind replacing the NULL values then someone will be able to help