Skip to main content
Documentation
Documentation
Adaptive Planning
Last Updated: 2025-07-25
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. We only suppress account and level rows with no splits. We don't suppress modeled accounts with links.
  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.