SAP Knowledge Base Article - Public

3148642 - How to display zero (0) instead of a dash (-) on a Table in SAP Analytics Cloud?

Symptom

  • Table shows dash.
  • Null values shows as a hyphen in a Table.
  • In a Table, when there is no data at the intersection of a column and a row, it displays a dash (-)
  • How to display the value zero (0) for a measure instead of a dash (-) in a Table on a Story in SAP Analytics Cloud?

Environment

  • SAP Analytics Cloud

Reproducing the Issue

  1. In SAP Analytics Cloud, create a Story.
  2. Insert a Table with at least one Dimension, and one Measure. 
  3. When viewing the Table, notice there is dash (-) that displays at the intersection of the row and columns that have no data.
    How to display the value zero (0), instead of a dash (-) in the Table?

Cause

  • No data always always displayed as a dash in a Table.
  • There is no option to change how no data is displayed in a Table, in SAP Analytics Cloud. 

Resolution

  • An enhancement was proposed on the SAP Customer Influence to request this functionality:

         https://influence.sap.com/sap/ino/#/idea/277061 
      
  • For information on product enhancement request, see the SAP Knowledge Base Article:

         2424376 - How do you create an enhancement request for SAP Analytics Cloud?

See Also

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,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud, https://hcs.cloud.sap, https://hanacloudservices.cloud.sap, https://cloudanalytics.accounts.ondemand.com, https://hanacloudservices-us.accounts.ondemand.com, https://www.sap.com, https://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software , KBA , LOD-ANA-DES , Story Design & Visualizations , How To

Product

SAP Analytics Cloud 1.0