SAP Knowledge Base Article - Public

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

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)

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

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

Keywords

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

Product

SAP SuccessFactors HXM Suite 2211