2515212 - How to get "number of years" an employee is working in the organization in ORD or Advance Reporting?

SAP Knowledge Base Article - Public

2515212 - How to get "number of years" an employee is working in the organization in ORD or Advance Reporting?

Symptom

  • Is it possible to get number of years an employee is working in company/ organization in ORD?
  • Calculate Number of Years in Organization in ORD

Environment

  • Online Report Designer
  • Advance Reporting

Resolution

  • Home > Analytics > Analytics > Detail Reporting Live Data / Advance Reporting > Calculated Column
  • Click on + button
  • Give the name of the Calculated Column 
  • Select Data Type as Number
  • Formula to calculate number of days in Organization is: Apply Age Function on Service Date 
  • (Select the Service Date field in the Formula > Double-click the Service Date field > In Token Editor Window: Click On Edit > Select Function: Age > Click on the Date > Select Dynamic Date Variable > Select Function Parameter: Today > OK > OK)
  • Instead of Service Date, Original Hire Date/ Original Start Date can also be used in the Formula

Number of Years in Company.png

Keywords

  • Age
  • Age ORD function
  • Number of Years in Organization
  • Number of Years in Company 
  • Calculate Number of Years
  • Service Date
  • Hire Date
, KBA , LOD-SF-ANA-ORD , Online Report Designer , Problem

Product

SAP SuccessFactors HCM Core all versions