SAP Knowledge Base Article - Public

2902217 - Error: "Formula could not be computed: Member *** is invalid and cannot be used in the formula. Try rewriting the formula" occurs when editing calculated measure on SAC story

Symptom

  • Error: "Formula could not be computed: Member *** is invalid and cannot be used in the formula. Try rewriting the formula" occurs when editing calculated measure on SAC story
  • The issue occurs when the calculated measure is created based on a Restricted Measure which is being used in Histogram chart

Environment

  • SAP Analytics Cloud 2020.5.2

Reproducing the Issue

  1. Logon SAC.
  2. Create a story with two tab pages.
  3. Create a restricted measure (measure1).
  4. Create a calculated measure (measure2) which includes measure1 in formula.
  5. Create Histogram chart in one tab (tab1), set measure1 in Measures.
  6. Create a table in the other tab (tab2), set measure2 in Columns.
  7. Try to edit measure2, find the error occurs.
  8. Remove measure1 from Histogram chart from tab1.
  9. Try to edit measure2 in tab2, no problem, measure2 can be edited.

Cause

This issue is currently under investigation by Development.

Resolution

This issue is currently under investigation by Development.

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 feature at the beginning of this article.
Thank you.

 

Keywords

Formula could not be computed, Histogram, calculated measure, restricted measure, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA-DES , Model, Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0