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

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

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

See Also

2515196 - How to get "number of days" an employee is working in the organization in ORD or Advance Reporting

2707073 - ORD / Report Canvas - Calculate Age / Service Period in Days / Months / Years

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 , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem

Product

SAP SuccessFactors HCM Core all versions