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 |