SAP Knowledge Base Article - Public

3072437 - INVALID_VALUE error happens when entering formula in SAC story

Symptom

INVALID_VALUE error happens when entering formula in SAC story

Environment

  • SAP Analytics Cloud 2021.7.7 (SAC)

Reproducing the Issue

  1. Create a story based on two blending models A and B.
  2. Add 3 calculated measures to the model, one for account from Model, one for account from Model B, one for computing a difference between those two accounts.
  3. Add the 3 calculated measures in table, it is ok.
  4. If add a new column to the table and try to select the column header, in formula bar, enter the formula calculating a difference between two previous columns :=C3-D3
  5. INVALID_VALUE error happens.

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.

Keywords

Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, currency, currencies, unit, column, table, cross, total, value, unit, invalid, formula, cell, calculation, calculate , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0