3317504 - Canvas report formatted value of Calculated column is not reflected in another calcaulation

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.

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

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.

It is an expected behavior.

Canvas report Calculated column will not be able to use the other formatted Calculated column values.

2707073 - How to calculate Age / Service Period in Days / Months / Years in ORD / Report Canvas 

format, formatted, canvas, advanced, report, calculated, column, value, values , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem