SAP Knowledge Base Article - Public

2714611 - Some numbers with 14 decimal places got changed after uploaded from Excel to SAP Analytics Cloud (SAC) Model

Symptom

Incorrect data shows for number type data with 14 decimal place in Excel when creating model using import excel file

Environment

  • SAP Analytics Cloud 2018.20.0

Reproducing the Issue

  1. Create an Excel file with several columns. One column’s data type is number with 14 decimal places. For example: one cell’s value is 43.06929500000000
  2. Logon to SAP Analytics Cloud.
  3. Create a Model based on the Excel created in step 1.
    => Note that 43.06929500000000 changed to 43.06929499999997.

Cause

The column is not being recognized as a number column, this happens because some of the values in that column contain an invisible character after the digits.

Resolution

Clean up those values and remove the invisible character at the end, SAC will be able to parse the number values correctly.

See Also

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

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, IEEE, float, change, unexpected, wrong, digital , 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 Predictive , Problem

Product

SAP Analytics Cloud 1.0