SAP Knowledge Base Article - Public

2877995 - Currency Convertion Rate field is displayed as text in calculated column

Symptom

Currency Convertion Rate field is being displayed as text (String) while creating calculated column in ORD/Canvas Detailed Reporting

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 HXM Suite

Reproducing the Issue

  1. Go to Report Center/Analytics
  2. Create an ORD/Canvas report
  3. Select the query type as Detailed Reporting
  4. Create a report of a compensation domain (e.g. Variable Pay)
  5. Select the field Currency Convertion Rate
  6. Check the Preview and see that the result will display numbers
    preview.jpg

  7. Create a calculated column and check that this field will be available under the Text type
    text calc.jpg

  8. Even if you apply the Raw function to the field (refer KBA 2339148)
    raw.jpg

  9. The result will always display 0
    preview_calc.jpg

Resolution

The type of "Currency Conversion rate" is text by design in the sub domain schema and cannot be changed.

Also, the workaround of Raw function works only if the text field (picklist) is associated to a number in the ID value (Column Formatting > Modified Data Type), which is not the case of the Currency Conversion rate (e.g. AAA|000).

Keywords

Currency Convertion Rate field is display string text in calculated column ORD detailed reporting , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , How To

Product

SAP SuccessFactors HXM Suite all versions