SAP Knowledge Base Article - Public

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

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

  1. Go to Report Center
  2. Create a Canvas report on Detailed Reporting Live Data / Advance Reporting > Calculated Column
  3. Click on + button
  4. Give the name of the Calculated Column 
  5. Select Data Type as Number
  6. Formula to calculate number of days in Organization is: Today - Service Date
  7. Instead of Service Date, Original Hire Date/ Original Start Date can also be used in the Formula

Number of Days in Company.png

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 all versions