SAP Knowledge Base Article - Public

3555775 - Value is displayed as 1.0E-2 when importing data from excel file to model

Symptom

  • Value is displayed as 1.0E-2 when importing data from excel file to model

Environment

  • SAP Analytics Cloud 2024.21.11 (SAC)

Reproducing the Issue

  1. Login to SAC system.
  2. Open import model
  3. Go to Data Management , upload Excel file as data source
  4. Open the Draft source, Click on the Grid view for Layout option
  5. Click on specific column
    ==>Notice that some of the values displayed as 1.0999999999999999E-2 format, and sometimes the validate data gives error

Cause

  • The issue is caused by product defect.

Resolution

  • The fix for the issue is planned to be released early to mid April

Keywords

E-2, import, SAC, model, data , management, upload, validate , data, format, number, text, type , KBA , LOD-ANA-ML-DE , SAC Data Wrangling , Problem

Product

SAP Analytics Cloud 1.0