SAP Knowledge Base Article - Public

3009932 - Decimal Number issue when admin use Import Data tool to import question

Symptom

Decimal number display abnormal in Answer Choice Value while using Import Data to import question


Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP SuccessFactors LMS

Reproducing the Issue

Reproducing Steps:
1. System Administration > System Management Tools > Import Data > Record Type: Question
2. Import File that contains decimal number in Answer Choice Value, for exmaple: 1.7
3. Content > Question Library > Search for the imported question > Answer Choice Value displays not 1.7 but 1.6999999999999999555910790149937383830547332763671875

* numbers like 0.5 stay the same, but other decimal number will all face the issue

・1.2 ⇒1.9999999999999999・・・・
・1.3 ⇒1.3000000004408920・・・・
・0.5 ⇒0.5

Cause

The precision setting from excel treating number as a decimal,this is not a defect with SF product.

Resolution

For the decimal numbers in the excel file, please use <p> tags. For example, 1.7 needs to be <p>1.7</p>

Keywords

SF SuccessFactors, LMS, Learning, import data tool, assessment, question , KBA , LOD-SF-LMS-IMP , Import Data Tool , How To

Product

SAP SuccessFactors Learning all versions