SAP Knowledge Base Article - Public

3054953 - How to set decimal places in Report Canvas using calculated column

Symptom

Set a field value to certain places of decimal using Calculated columns

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
  • Report Canvas
  • ORD Detailed reporting - live data
  • Advanced reporting
  • Calculated Columns

Reproducing the Issue

  • Create a report in Detailed Reporting - Live data or Advanced reporting.
  • Add a field of type Number in the report.
  • Set the field value to certain places of decimal.

Resolution

This requirement can be achieved by using Calculated column.

  • Create a calculated column and select the field of type number (whose value you want to set to certain places of decimals in the report) in the value box. (step 1)
  • Click on "Edit Format" to format the integer to decimal (Step 2)
  • Select the 'Decimal Places' to get the value of the field in the report in decimals (Step 3)
  • Save the changes.


See Also

2890207 - How to create a calculated column on a Canvas report?

Keywords

Ord, advanced, reporting, detailed, live, data, calculated, column, decimal, place, integer, calculation , KBA , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , How To

Product

SAP SuccessFactors HXM Suite all versions

Attachments

Pasted image.png