SAP Knowledge Base Article - Public

2965948 - Age is calculated incorrectly on People Analytics Standard report

Symptom

Age is calculated incorrectly on People Analytics Standard report. The date is being rounded up.

"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

Cause

The date is being rounded up on the standard report because the calculation of the formula is Rounded. See below:

ROUND(DAYS_BETWEEN([Person#Biographical Information#Date Of Birth],CURRENTDATE())/365,0)

Resolution

With this formula the system will round the date up or down depending on the current date and the employees Birthdate. 
 
In case you do not want that the date be rounded it is possible to change the calculation to Days in Between as below:
 
  • DAYS_BETWEEN([Employment#Job Information#Service Date],CURRENTDATE())/365 
    This is how it should look like:



There are also two possible workarounds to be used.

  • It is possible to subtract 0,5 from the result then the end result will always round down correctly. For example 25,6 - 0,5 = 25,1 will become 25 or 24,9 - 0,5 = 24,4 = 24. Here is an example of a calculate column code used for Org Tenure:
    ROUND( (DAYS_BETWEEN([Employment#Job Information#Hire Date],CURRENTDATE())/365)-0.5,0 ) ”

  • “Another calculation suggested
    IF((MONTH([Person#Biographical Information#Date Of Birth])>MONTH(CURRENTDATE())
    or (MONTH([Person#Biographical Information#Date Of Birth])=MONTH(CURRENTDATE()) and
    DAY([Person#Biographical Information#Date Of Birth])>DAY(CURRENTDATE()))),
    (YEAR(CURRENTDATE())-YEAR([Person#Biographical Information#Date Of Birth]))-1,
    YEAR(CURRENTDATE())-YEAR([Person#Biographical Information#Date Of Birth]))”

Keywords

Age, Calculate, incorrect , KBA , LOD-SF-ANA-SAC , People Analytics (Analytics Cloud for SF) , Problem

Product

SAP SuccessFactors HXM Suite all versions

Attachments

Pasted image.png