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:

1. In a grid, select the rows or columns to suppress, or select the entire grid.
2. In Properties, under Suppression, select Advanced Options, and then click .
3. In the Conditional Suppression, dialog box, define what to suppress:
   1. For Suppress Row/Column: If, select a property value from the drop-down.
   2. Depending on the property value you select, you may be able to enter a reference value.

      For example, if you select "Generation," then you can click the drop-down to select a reference value of "Period," "Version," "Account," "Entity," "Product," "Year,", "HSP_View," or "Scenario." If you select "Value in Cell,", then A, 1 is automatically filled in. You can change this value if desired.

   3. Select a comparison operator.

      • = (equal to)

      • < > (less than or greater than)

      • > (greater than)

      • > (greater than)

      • > = (greater than or equal to)

      • < = (less than or equal to)

      • equals (is equal to)

      • not equals (is not equal to)

      • starts with

      • ends with

      • contains

      • is

   4. Select a comparison option.

      • Value—Returns the cell location; for example, A, 3.

      • Cell Value—Returns the cell location; for example, A, 3.

      • Row Value—Returns the number of the row.

      • Column Value—Returns the letter of the column.

      • Zero—Assigns zero value for condition.

      • No Data/#MISSING—Indicates no data value for selection.

      • Error—Assigns the condition as an error.

      • String—Enables the definition of a string for the condition.

      • 0, 1, 2—Indicates the number of levels or generations in the selected dimension.

      Note: The options in the drop-down list depend on the property value you selected.

   5. Depending on the comparison option you select, a reference value may be filled in. You can type in a value, or click the drop-down to change the value if desired.

      You can type in a value, or click the drop-down to change the value if desired. For example, if you select "Cell Value, "then the reference value is automatically populated with "A, 1." At this point, you can keep this value or type in a new value. If you select "Generation," then the reference value is automatically populated with "Period." At this point, you can keep this value, or click the drop-down to select a new value.

4. Optional. In the Options area, add one of the following logic options to your condition:

   • Allow Not—Allow suppression only if the condition is not met.

   • Allow Parentheses—Define precedence, or order of consideration for conditions, and specify the set of conditions as intended.

5. Optional. Click to add additional conditions.

   You can add up to seven conditions.

   If you add additional conditions, select And to combine a condition with the next condition, or select Or to distinguish a condition from the next condition.

6. Click OK to return to the grid.

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.