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)
- Analytics & Reporting (Ad Hoc, YouCalc, ORD)
Resolution
- Edit the Canvas Report (Detailed reporting/ Advanced reporting)
- Go to Calculated columns
- Create a new calculated column - add the 'Number' as data Type.
- Click on 'Edit Format' - enable 'Use Custom format'
- 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
Attachments
Pasted image.png |