SAP Knowledge Base Article - Public

2932161 - How to create a calculated column to count the number of days that a position is opened?

Symptom

How to create a calculated column to count the number of days that a position is opened?

Environment

  • SAP SuccessFactors HXM Suite
  • Advanced Reporting

Resolution

  1. After the report on Position is created and the table is added
  2. Go to the calculated columns section on the advanced reporting and created new
  3. After that it is required to add a token block and select date
  4. Then select dynamic date and select today (screenshot below)
  5. Add a Minus operator on the right of the token and the Effective Star Date for the calculation (screenshot below).

  6. Then a name must be given 

Keywords

calculated column count the number of days  , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem

Product

SAP SuccessFactors HXM Suite all versions