1. Administering and Working with Enterprise Profitability and Cost Management
  2. Analyzing Data
  3. Working with Data in Forms
  4. Working in Forms 1.0
  5. Basics of Working With Data
  6. Personalizing How Data Displays
  7. Hiding Rows or Columns That Have No Data or Zeros

Hiding Rows or Columns That Have No Data or Zeros

To simplify the data in a form, you can hide rows that have no data or contain zeros.

To hide rows that have no data or contain zeros:

  1. Click Actions, and then Filter.
  2. Click an option:

    • Hide rows with no data: To toggle between hiding and showing rows that have no data (displayed as #MISSING or blank, depending on how your administrator set this property). This option is not displayed if your administrator has set the form's property to Suppress Missing Data.

    • Hide rows with zeros: To toggle between hiding and showing rows that have zeros for values.

    • Hide rows with zeros and no data: To toggle between hiding and showing rows that have either no data or zeros, or both.

To hide columns that have no data or contain zeros, follow these steps, but select columns instead of rows.