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

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

• SAP Analytics Cloud 2018.20.0

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.

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.

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

• How to find User Assistance for SAP Analytics Cloud?
• Ask a question on the SAP Community!
• 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud (Hint: Use component LOD-ANA*)

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

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