SAP Knowledge Base Article - Public

2929815 - Calculate Tenure in Months using calculated column in ORD (Report – Canvas)

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

Product

SAP SuccessFactors HCM suite all versions