SAP Knowledge Base Article - Public

2408675 - REF_ERR in table cells using formulas in SAP Analytics Cloud

Symptom

  • When using a dependent formula, changing a filter on data in a table results in REF_ERROR.
  • It is not possible to set a fix anchor to a cell.

Environment

  • SAP Analytics Cloud

Reproducing the Issue

  1. Create a table on a story canvas and add a formula (EX: =A1+B1 in cell C1)
  2. Create a separate formula in a different the table using the previous formula cell as a value in the formula (EX: =C1/D1)
  3. Save and reopen the story.
  4. Change the filter on the data in the table (EX: Change date range filter in calculation of A1 data)
  5. Notice the table view on the cell with a formula reverts back to the text value box, and the calculation results in a REF_ERROR
  6. Examine the formula to see it has changed to =REF_ERR+REF_ERR

Cause

  • Applying filters in tables changes the references of the cells and the formula can't be calculated.

Resolution

  1. Vote on this improvement request. 
  2. Follow up on it in order to get updates on when it is implemented.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Hana Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud , KBA , references error into tables , 2 values in different cells , grids grid dtc , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , Product Enhancement

Product

SAP Analytics Cloud 1.0