Use ZN(), IFNULL() function.
If this not help, please attach sample workbook.
If you are creating buckets and then want to add 0 when there is no value for a bucket, try to use LOD expression and IFNULL() function in the calculation.
If this not help, Please attach sample workbook.
Thanks for replying. I tried both the suggestions and they are not working. Actually there is no data in the underlying data source for the cells where there is blank space. Is there a way to work around this? a way to mask the blank spaces(with no underlying data) with 0?
You can refer to the link mentioned below which has an option of replacing null with 0 while the data is missing.
Maybe this can help.
Have a Nice Day!