2965948 - Age is calculated incorrectly on People Analytics Standard report

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."

SAP SuccessFactors HXM Suite

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)

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:

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

SAP SuccessFactors HXM Suite all versions

Pasted image.png