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

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

There is an enhancement request in SAP Idea Place, you can vote and follow this idea: https://ideas.sap.com/D42701

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating facility at the top right-hand corner of this article.
Thank you.

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 , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0