average

[#1]

I want to calculate the average of formula below but doesn't succeed.

=round(round(((count({$<HR_Calendar.Year = ,HR_Calendar.MonthName = , IsNuInDienst = {'indienst'}>} Empl.NAME)-

if(count({$<HR_Calendar.Year = ,HR_Calendar.MonthName = , IsNuInDienst = {'indienst'}>} Empl.NAME)>0,1,0))),0.01)/12

      ,0.01)

[Gysbert_Wassenaar]

If you want an average of counts you need to use the aggr function.

avg(aggr(

round(rangemax(0,count({$<HR_Calendar.Year = ,HR_Calendar.MonthName = , IsNuInDienst = {'indienst'}>} Empl.NAME)-1)/12,0.01)

, Dim1, Dim2, ... DimN)

Replace Dim1, Dim2, ... DimN with the dimensions over which you want to aggregate the average.

[#3]

I assume you are dutch

De bedoeling is om de gemiddelde functieverblijftijd van medewekers te berekenen. Deze functieverblijftijd wordt gebaseerd op het aantal maanden dat mwd op een bep functie staat. Kan je de formule in zijn geheel aanpassen, want krijg foutmelding.

Alvast bedankt !!

=round(round(((count({$<HR_Calendar.Year = ,HR_Calendar.MonthName = , IsNuInDienst = {'indienst'}>} Medewerker.NAAMLANG)-

if(count({$<HR_Calendar.Year = ,HR_Calendar.MonthName = , IsNuInDienst = {'indienst'}>} Medewerker.NAAMLANG)>0,1,0))),0.01)/12

,0.01)