2086010 - Result not making sense? - Information regarding Rounding, Averaging and Annualisation onsite - WFP

SAP Knowledge Base Article - Public

2086010 - Result not making sense? - Information regarding Rounding, Averaging and Annualisation onsite - WFP

Symptom

  • Have a Result that is not making sense?

Environment

  • Worforce Planning and Analytics

Resolution

  • Is the result correct at the monthly and quarterly level, but wrong at the annual level? (Annualisation)
  • Measure annualisation is calculated as follows:
  • ((Sum(all available months of data))/(Count(all available months of data))) * 12
  • For example, annualising 7 months of Total Termination data gives the following result:
  • ((Total Terminations (January to July) = 16,437)/7)*12 = 28,178

 

  • Is rounding impacting the result?
    Example
    77/73 = 1.05479... (when calculated on a calculator), which as a percentage result would be 105.5% or as a whole number 106%
    Result showing onsite is - 105.2% Why?
    In this instance the denominator and numerator are being annualised BEFORE the calculation occurs, and then rounded for appearances onsite (showing as 77/73)
    The calculation however, uses a true figure from the cube, not the rounded figure showing onsite. (so may be (76.79/73.01) = 105.18559...
    Onsite would display as - 77/73=105.2%

 

Two different results when averaging same set of data?

I ran 2 queries per actual average unscheduled Absence per Employee - Sick Leave (FTE) over FY 08/09:

 

  • Query 1: Unscheduled Absence per Employee - Sick Leave (FTE) - All Org Units, All Genders, All Ages, All Organisation Tenures, All Regions, Period: 08/09
  • Query 2: Unscheduled Absence per Employee - Sick Leave (FTE) - All Org Units, All Organisation Tenures, All Regions, 08/09 - this is the same query as above but I have removed the Dimensions

 

All Genders and All Ages.

 

  • The average of all data (ascertained by highlighting all figures in the excel table) in Query 1 is 8.44, whereas the average of all data in Query 2 is 6.77!
  • This is best explained by simplifying the query to using just Tenure for a particular organisational unit.

 

 

Unscheduled Absence Days per FTE  
 All Org  Tenures  CEO
All 6.67
<1 6.51
1-<3 6.43
3-<5 4.19
5-<10 6.51
10+ 6.82

 

 

Unscheduled Days Absent
 All Org  Tenures  CEO
All 903
<1  73
1-<3  107
3-<5  48
5-<10  160
10+  514

 

 

 

 FTE 
 All Org  Tenures  CEO
All 135.33
<1 11.21
1-<3 12.70
3-<5 11.45 
5-<10 24.57
10+ 75.40

 

  • If you use excel to average the nodes under All Org Tenures
  • (6.51 + 8.43 + 4.19 + 6.51 + 6.82)/5, the result is 6.49.
  • This is a different result to the All Org Tenures result of 6.67.
  • This difference in results occurs because weighting has not been taken into account. If all samples are of equal size, then an arithmetic average of the average will be correct. If sample size is different then it will be incorrect when compared with the weighted average.
  • In this example, each of the All Org Tenures nodes has a different (FTE) sample size (11.21, 12.70, 11.45 etc). So to find the true average, you need to add the All Org Tenure nodes for Unscheduled Days Absent and then divide by the addition of the All Org Tenure nodes for FTE. E.g.:
    (73 + 107 + 48 + 160 + 514) / (11.21 + 12.7 + 11.45 + 24.57 + 75.4) = 6.67

Keywords

KBA , LOD-SF-WFA-WA , Workforce Anaytics , How To

Product

SAP SuccessFactors HCM Core all versions