SAP Knowledge Base Article - Public

3555514 - Can't edit story calculation based on Client Calculation - SAC

Symptom

  • Unable to edit story calculation based on Client Calculation in SAP Analytics Cloud.
  • The issue arises when inserting a table widget with two or more columns, marking two of these columns, and adding a client calculation.
  • The problem is observed in the builder panel where clicking on "Edit Calculations" for the new measure in the "Story calculations" area results in no action.
  • However, if a new key figure is created by clicking on "Add Calculations..." in the builder area for the key figures, it can be edited afterwards via "Edit Calculations".

Environment

SAP Analytics Cloud 

Reproducing the Issue

  1. Insert a Table-widget with 2 or more columns.  
  2. Mark 2 of these columns.
  3. Add Client calculation => Multiply => Repeating.
  4. Check the Builder Panel.
  5. Click on "Edit Calculations" for this new measure in the "Story calculations" area.

Resolution

  1. Navigate to the Builder panel of your story.
  2. Look for the dimension to which the calculated row or column was added.
  3. Expand the list of calculations under this dimension.
  4. In the list, you will see your calculated rows or columns referred to as "Story Calculations."
  5. Select the story calculation and click on the "Edit calculation" option.
  6. The calculated column or row will be highlighted in the table, and the formula will be displayed in the formula bar for you to modify.

See Also

Create Client Calculations in Table Cells | SAP Help Portal

Keywords

SAC, story, calculation, builder, table, widget, column, row. , KBA , LOD-ANA-TAB , Table , Problem

Product

SAP Analytics Cloud 1.0