Symptom
- A story formula(for example, runningsum()) displays the incorrect value intermittently. Once refresh the story, the issue is resolved, till the same issue occurs again.
- Clear the cache and hard reload of the chrome does not resolve the issue.
Environment
- SAP Analytics Cloud (Enterprise) 2022.15.8
Reproducing the Issue
- Open a story which has a story formula.
- Notice the value is incorrect.
- Refresh the story. The value for the story formula is displayed correctly.
Cause
During the investigation, it was identified table widgets containing the calculation was duplicated.
When duplicating table widgets, the calculation is not copied but shared between tables, which leads to the calculation result being incorrect between tables.
Resolution
Keywords
KBA , LOD-ANA-TAB , Table , Problem
Product
SAP Analytics Cloud all versions
By deleting and recreating the calculation, the issue is resolved. The duplicated tables do not share the same calculation any more.