SAP Knowledge Base Article - Public

3194009 - How to customise number format of a field in Canvas report

Symptom

By default, the canvas report fetches the number field like 1000000 without any format.
This KBA will explain how to format the above number field like 1,00,000 or any similar format. Need to create a calculated column to achieve this.

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

Environment

  • SuccessFactors HXM Suite
    • Analytics & Reporting (Ad Hoc, YouCalc, ORD)
      • Online Report Designer
      • Advanced Reporting (ODS)

Resolution

  1. Edit the Canvas Report (Detailed reporting/ Advanced reporting)
  2. Go to Calculated columns
  3. Create a new calculated column - add the 'Number' as data Type.
  4. Click on 'Edit Format' - enable 'Use Custom format'
  5. Use the format as '0,000,000' or the required format.


Keywords

Canvas, detailed, report, calculated, column, columns, format, number, advanced , KBA , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , How To

Product

SAP SuccessFactors HXM Suite 2205

Attachments

Pasted image.png