3593775 - 0 is displayed differently in Optimized Story and Classic Story in SAP Analytics Cloud

After converting a classic story to ODE story, some values show "+/- 0" instead of "0" as seen in the classic story.

SAP Analytics Cloud

1. Access the classic story.
2. Observe that the value is displayed as "0".
3. Access the converted optimized story.
4. Observe that the value is displayed as "+/- 0".

The reason that table displays +0 or/and -0 is because the values returned from the backend are not exactly 0, and this behavior in ODE stories is by design to improve accuracy. 

You can check the raw value in the Formula Bar (go to the Tools menu and enable the Formula Bar).

Click on the cell with the +0 value and you will see in the formula bar that the value is a positive decimal number close to 0, but not exactly 0.

If the value is a positive decimal number (e.g. 0.0000675 ), the table cell will display it as +0.

If the value is a negative decimal number (e.g. - 0.0000675), the table cell will display it as (0) or -0 (depending on the styling).

In ODE, Table will only display 0 if the value returned from the backend is exactly 0 (with no decimal point).

• 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
• 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 a case for SAP Analytics Cloud?
• Search for SAP Analytics Cloud content using Google or Bing:
  
  • https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
  • https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
  • Note: Add relevant text or warning/error messages to the text search field to filter results.
• SAP Analytics Cloud > Learning > Data Connections
• 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.

SAP Analytics Cloud, Display Result, Converted Optimized Story, Classic Story, Value Display, +/- 0, 0, opposite, value, ODE, Optimized Experience, story , KBA , LOD-ANA-TAB , Table , Problem