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
See Also
Keywords
- Age
- Age ORD function
- Number of Years in Organization
- Number of Years in Company
- Calculate Number of Years
- Service Date
- Hire Date
Product
SAP SuccessFactors HCM Core all versions