Symptom
The Canvas advanced reporting has one Calculated column and the result is formatted.
The above value will not reflect in another calculated column calculation.
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
- Analytics & Reporting (Ad Hoc, YouCalc, ORD)
- Advanced Reporting (ODS)
- Analytics & Reporting (Ad Hoc, YouCalc, ORD)
Reproducing the Issue
1. Create a calculated column in Canvas report, example calculate Age from the Date of Birth and set the column formatting Decimal places to 0.
2. The report will fetch the Age in Whole numbers.
3. Create another calculated column using above calculation. Consider calculating 'Years left for Retirement'.
4. The values will always use the original Age value without the formatted one. That means Age with decimal values will be considered in the above Calculated column.
Resolution
It is an expected behavior.
Canvas report Calculated column will not be able to use the other formatted Calculated column values.
See Also
Keywords
format, formatted, canvas, advanced, report, calculated, column, value, values , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem