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:
 

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