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

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.

• SAP SuccessFactors HXM Suite
• Report Canvas
  
• Advanced reporting
• Calculated Columns

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

This requirement can be achieved by using Calculated column.

1. 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)
2. Click on "Edit Format" to format the integer to decimal (Step 2)
3. Select the 'Decimal Places' to get the value of the field in the report in decimals (Step 3)
4. Save the changes.

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

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