Show TOC

Empty Cell Default Value Locate this document in the navigation structure

The Empty Cell Default Value is the label that can be displayed in any report cell of the current sheet that has no data.

By default, the number 0 will appear in the cells. You can enter a value of your choosing, such as:
  • Blank. The cell is left blank.
  • N/A. "N/A" appears in the cell.
  • #Missing
Note Empty cells (no data) are not the same as cells with zero in them, although it is recommended they be treated as zero in calculations.
Note You can specify a different empty cell value for a specific report in the Options tab of the Report Editor.