SAP Knowledge Base Article - Public

2633562 - Incorrect numeric values after importing data from an Excel or CSV file in SAP Analytics Cloud

Symptom

You have a CSV or Excel file with numeric values such as 0.015 and -0.004.

After creating a model, you visualize the data in a story and see the following values: 150.00 and 4.000

Environment

  • SAP Analytics Cloud

Cause

The numeric format selected during the process of importing (wrangling) was incorrect, with the decimal value selected as comma rather than dot.

IncorrectNumberFormat.png

Resolution

Select the number format that matches the file you are using.

In this case, select the decimal separator as dot:

Number_format.png

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

negative, sum, aggregation, add, text, comma, decimal, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, 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 , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predicitive , Problem

Product

SAP Analytics Cloud 1.0