SAP Knowledge Base Article - Public

3804934 - Cannot delete "*" in total row of a story table measure in SAP Analytics Cloud (SAC)

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

  1. Open a story that contains a table with a percentage measure configured with Aggregation Type = None.
  2. Locate a total row in the table where the measure shows “*”.
  3. 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

  1. The solution of this issue is currently under investigation. Please follow this KBA for updates.
  2. Workaround: In the affected total cell showing “*”, enter “0”.
  3. After entering “0”, delete the “0” to clear the cell.

See Also

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