Skip to main content
Documentation
Documentation
Adaptive Planning
Last Updated: 2023-06-23
Suppress Zeros and Blanks on Modeled Sheets

Suppress Zeros and Blanks on Modeled Sheets

Security:
Access Sheets
 permission.
You can hide modeled sheet rows that contain cells with only zeros and blanks.
  2. From the modeled sheet toolbar, select
    Display Options
    .
  3. Select
    Filter Rows
    .
  4. From the
    Column
     prompt, select a column that holds numerical values.
  5. From the
    Comparison Type
     prompt, select
    not equal to,
     and enter
    0
     in the
    Enter Value
     text box.
  6. Select
    Add Group
    .
  7. From the
    Column
     prompt, select any column that has text.
  8. From the
    Comparison Type
     prompt, select
    is not empty
    .
  9. Add an
    is not empty
     group for each column that has text.