Grid Properties - Suppression Category

Table 37. Grid Properties - Suppression Category

Item	Use
Hide Grid	Hides, but not remove, the grid. The grid's title bar is disabled on the Design tab.
Suppression	You can select Basic and Advanced option for conditional suppression. Select Basic Options to suppress data based on any of the following methods: Select If Zero, Suppress to suppress all values that equal zero. If all data values in a given row or column equal zero, the entire row or column is suppressed. Select If Missing, Suppress, to suppress all cells that do not contain data. If all cells in a given row or column do not contain data, the entire row or column is suppressed. Select If Error, Suppress to suppress data in cells that cannot be retrieved or calculated because of errors. If all data values contain errors in a given row or column, the entire row or column is suppressed. Select Advanced Options to suppress data based on specific criteria, then select Setup to define criteria. For Planning data sources only: Select Missing Blocks to include a data query level flag called SuppressMissingBlocks in any ADM data query which gets issued to Planning for that grid. This property acts independently from any other suppression property and is available at the grid level only (not the row/column level).
Text Options	Enter a value in any of the following areas: In Zero Values, enter a value to replace zero value cells. In No Data, enter a value to replace empty cells. In Error, enter a value to replace error value cells. Show Text Functions Errors, select to enable errors to display for text functions that are placed in the grid. This is the default.

Item

Use

Hide Grid

Hides, but not remove, the grid. The grid's title bar is disabled on the Design tab.

Suppression

You can select Basic and Advanced option for conditional suppression.

Select Basic Options to suppress data based on any of the following methods:

Select If Zero, Suppress to suppress all values that equal zero. If all data values in a given row or column equal zero, the entire row or column is suppressed.
Select If Missing, Suppress, to suppress all cells that do not contain data. If all cells in a given row or column do not contain data, the entire row or column is suppressed.
Select If Error, Suppress to suppress data in cells that cannot be retrieved or calculated because of errors. If all data values contain errors in a given row or column, the entire row or column is suppressed.

Select Advanced Options to suppress data based on specific criteria, then select Setup to define criteria.

For Planning data sources only: Select Missing Blocks to include a data query level flag called SuppressMissingBlocks in any ADM data query which gets issued to Planning for that grid. This property acts independently from any other suppression property and is available at the grid level only (not the row/column level).

Text Options

Enter a value in any of the following areas:

In Zero Values, enter a value to replace zero value cells.
In No Data, enter a value to replace empty cells.
In Error, enter a value to replace error value cells.
Show Text Functions Errors, select to enable errors to display for text functions that are placed in the grid. This is the default.