3668372 - SAC - Null and zero suppression feature not working as expected

• The null and zero suppression feature fails to work consistently, successfully hiding some rows while leaving other rows with zeros or nulls fully visible.
• The suppression function works correctly for a subset of rows, successfully hiding zeros and null values as expected.
• For a different subset of rows, the feature fails. Zeros and null values remain fully visible despite the option being active.

SAP Analytics Cloud 

1. Open the affected story and table.
2. Enable the "Suppress Zeros/Null" option in the table's settings.
3. Observe that while some rows with zeros/null are hidden correctly, others remain visibly unchanged.

• The system is functioning as designed.
• The "Zeros/Null suppression" feature is intended to hide entire rows or columns only if every measure value within them is zero or null.
• It cannot suppress individual cells, as this would break the table structure.

Proposed workaround: 

• Convert the measure's type to string to display blank cells instead of dashes.
• Refer to the community post for guidance: Replace NULL with blank in column.

• 3031811 - Zero suppression does not work in SAP Analytics Cloud (SAC)
• Replace NULL with blank in column

zero suppression, null suppression, suppress zeros, suppress nulls, inconsistent suppression, table settings, SAC, SAP Analytics Cloud, blank cells, dashes, measure type conversion, hide rows, hide columns, suppression feature, SAC, hide cell  , KBA , LOD-ANA-PL-DE , Data Entry and Mass Data Entry , LOD-ANA-TAB , Table , LOD-ANA-PL , Planning , Problem