Symptom
- In a story table, the total row for a measure displays “*” and attempting to delete the total cell does nothing.
- Workaround: entering “0” in the total cell replaces “*”; deleting the “0” then clears the cell.
- Message shown: “The value can't be shown because the aggregation type for this node is set to ‘None’ or is equivalent to ‘None’.”
Environment
SAP Analytics Cloud Version 2026.15.6
Reproducing the Issue
- Open a story that contains a table with a percentage measure configured with Aggregation Type = None.
- Locate a total row in the table where the measure shows “*”.
- Attempt to delete the “*” directly in the total cell; observe it cannot be cleared.
Cause
A product defect causes total cells displaying “*” to be non-deletable directly for the affected measure configuration.
Resolution
- The solution of this issue is currently under investigation. Please follow this KBA for updates.
- Workaround: In the affected total cell showing “*”, enter “0”.
- After entering “0”, delete the “0” to clear the cell.
See Also
- KBA 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- KBA 2487011 - What information do I need to provide when opening a case for SAP Analytics Cloud?
- KBA 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- SAP Analytics Cloud Connection Guide
- SAP Analytics Cloud Get More Help and SAP Support
- Need More Help? Contact Support
Your feedback is important to help us improve our knowledge base.
Keywords
SAC, story table, total row, asterisk, star value, cannot delete total, non-editable total, exception aggregation None, average rate type, percent measure, planning table, clear total value, enter 0 workaround, total cell edit, measure total "*" , KBA , LOD-ANA-TAB , Table , LOD-ANA-PL-DE , Data Entry and Mass Data Entry , Problem
Product
SAP Analytics Cloud 1.0
SAP Knowledge Base Article - Public