Symptom
- Is it possible to get number of days an employee is working in company/ organization in ORD?
- Calculate Number of Days 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
- SAP SuccessFactors HXM Suite
- Report Canvas
Resolution
- Go to Report Center
- Create a Canvas report on Detailed 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: Today - Service Date
- Instead of Service Date, Original Hire Date/ Original Start Date can also be used in the Formula
See Also
2515212 - How to get "number of years" 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, Number of Days in Organization, Company, Calculate, Service Date, Start, Hire , 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 Suite all versions