How to show Zero (instead of empty) in No Data cell
Originally posted by Hubert Gao
Hello,
In CubeView, is there any setting to show Zero for No Data cell instead of showing empty cell?
Thank you!
Forum Discussion
This can be done with the ReportNoDataNumberFormat option in the Cell Format Settings for the rows or columns.
ReportNoDataNumberFormat By default, XF displays NoData (i.e. null) cells as empty text in the Data Explorer and as zeroes in a report. However, any .NET number format text can be specified to format those zero values differently in the report. For example, show the word NODATA if desired by typing NODATA in that setting. To display empty text, type # in that setting. If the cell’s number format setting already does something with null values, this property does not need to be filled.
You can use any of the number formats listed in the object lookup.
Hope this answers your question.
I would like to also follow up on this. Can you please explain how to leverage this functionality for the data explorer view?
Thank you!
