SAP Knowledge Base Article - Public

2810963 - Number format decimals Adhoc and Compensation form - Adhoc Reporting

Symptom

  • The number format of currency fields in compensation/variable pay forms is not the same as in Adhoc reports
  • There are more decimal places for currency fields in the Adhoc report if compared to the Compensation form

Environment

SAP SuccessFactors HCM Suite

Reproducing the Issue

  1. Go to Compensation form
  2. Open the form of an employee
  3. Check the value of one currency field e.g. Total Pay is $589
  4. Now run an Adhoc report and check that the result for this employee is Total Pay 588.99999

Resolution

The data in Adhoc is retrieved from db directly and no number format is applied.

The result in csv for this case will be 588.99999. In Excel, if you apply a number formatting with no decimal places, the result will be 589.

Keywords

 Number format decimals Adhoc report and Compensation form currency money field variable pay , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , LOD-SF-CMP , Compensation Management , How To

Product

SAP SuccessFactors HCM Suite all versions