Defining Advanced Conditional Suppression
Use advanced conditional suppression to suppress rows or columns in a grid based on specified attributes or values. Conditional suppression can be simple or complex, and can contain a maximum of seven conditions. You can combine advanced conditional suppression with basic suppression options. See Defining Basic Conditional Suppression.
When you define conditions, you can include the Not operator to suppress rows or columns that do not meet the condition (that result in false), and parenthesis to enclose and separate conditions from other conditions. Conditional suppression may be based on data or formula values.
To suppress data:
Note that the Conditional Suppression dialog box displays one of the following labels above the suppression options:
-
Basic Options:None—Basic options not selected with Advanced options.
-
If Zero, Suppress OR—If Zero is selected with Advanced options.
-
If Zero OR Missing, Suppress OR—If Zero and If Missing are selected with Advanced options.
-
If Zero OR Error, Suppress OR—If Zero and If Error are selected with Advanced options.
-
If Zero OR Missing OR Error, Suppress OR—If Zero, If Missing and If Error are selected with Advanced options.
-
If Missing, Suppress OR—If Missing is selected with Advanced options.
-
If Missing OR Error, Suppress OR—If Missing and If Error are selected with Advanced options.
-
If Error, Suppress OR—If Error is selected with Advanced options.