Symptom
Story level calculation(division) returns inaccurate value
Environment
SAP Analytics Cloud 2020.21.6
Reproducing the Issue
- Open the story
- Edit the story and Go to Builder Panel
- Open the calculation in Calculation Editor
- Click inside the Edit Formula, the formula used : ["IFP":A2_E1200]/["IFP":ST100]
- The Second Measure used in the formula ["IFP":ST100] is different from the measure used in table is ["IFP":ST111]
- To check this, In the Builder Panel , Please change the display option of BS and P&L to ID to see the measure used in the table.
- Please find the attached file for the calculation step by step.
- Change the calculated formula with ["IFP":A2_E1200]/["IFP":ST111], Format the calculation with 0 in the Decimals.
Cause
Product bahavior by design
Resolution
- The Formatting Dialogue box works as a template, we can use for different type of calculations. Here in this case , the calculation is related to currency. In another example, If we are calculating the measures with percentages , then the expected result will be like 2 %. If the measures are with kilometers , the result will be like 4 km etc..
- To change the Formatting specific to currency , Please use SAP influence site links to send your inputs for the future releases.
See Also
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- 2851317 - Where can I find more information on SAP Analytics Cloud (SAC) for Planning features and documentation?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening an case for SAP Analytics Cloud?
- SAP Analytics Cloud > Learning > Guided Playlists
- SAP Analytics Cloud > Learning > Guided Playlists > Getting Support
- Need More Help? Contact Support or visit the solution finder today!
Your feedback is important to help us improve our knowledge base.
Keywords
SAP Cloud for Planning , sc4p , c4p , cforp , cloudforplanning , Cloud for Analytics , Cloud4Analytics , CloudforAnalytics , Cloud 4 Planning , BOC , SAPBusinessObjectsCloud , BusinessObjectsCloud , BOBJcloud , BOCloud. , SAC , SAP AC , Cloud-Analytics, , CloudAnalytics , SAPCloudAnalytics, divide, division, formatting, format, inconsistent, wrong, incorrect, value, result, measure , KBA , LOD-ANA-DES-CAL , SAC Story Calculations , LOD-ANA-PL , Planning , Product Enhancement