Suppress Zeros and Blanks
You can hide rows if all the row cells are zero or blank in:
- Cube sheets by usingDisplay Optionsin Cube view. Workday automatically suppresses zeros by default in Columnar view for all accounts where you can enter data; in this view, you can only enter data on editable standard, entered GL/custom, and assumptions accounts. When you switch from Columnar to Cube view, Workday restores your Cube view suppression configuration.
- Standard sheets by usingDisplay Options.
- Modeled sheets by filtering out rows with zeros and blanks using theFilter Rowstab inDisplay Options.
When you suppress zeros and blanks, you won't be able to enter new data in rows that need data. In cube sheets, you can add a specific row while keeping the blank and zeros rows hidden.
When you access
Explore Cell
from sheets, dashboards, and reports, the contributing details shown in the bottom section of the window are automatically suppressed if all values are zeros or blanks. You might still see rows with zeros when the zero is a result of:
- Formula errors.
- Rounding from the Decimal Places account setting.