Symptom
We come across various scenarios while reporting when we need to calculate the tenure in terms of months i.e. number of months between two given dates.
Environment
SAP SuccessFactors HXM Suite
- Report Canvas
- Advanced Reporting
- ORD Detailed Reporting - Live Data
Reproducing the Issue
Calculate the tenure in terms of months i.e. number of months between two given dates.
Resolution
In the following blog post, we will discuss how to calculate the tenure in terms of months using calculated columns in ORD.
https://blogs.sap.com/2020/05/22/calculate-tenure-in-months-using-calculated-column-in-ord/
Keywords
ORD, Advanced, Reporting, Detailed, Live, data, calculated, column, month, tenure, difference , KBA , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem