MikeBottema
Technical User
I am looking for help on a turnover rate report. Similiar to the one in Enterprise V4 (PER010) but I need to show turnover by position and not by department.
Below is the forluma used to calculate the Turnover Rate Report (PER101) in EV4.
Turnover Rate[x] = Average # of employees between two dates (Begin Count [d] + End Count [e]/2) divided by (Terminations[a] + Retirements + Transfer Out[c])
move &BeginCountC to #BeginPlusEnd
add #EndCountC to #BeginPlusEnd
if #BeginPlusEnd > 0
! Separations include terminations and retirements
move #TermsC to #Net_Turnover
add &RetireCountC to #Net_Turnover
multiply 200 times #Net_Turnover
divide #BeginPlusEnd into #Net_Turnover
move #Net_Turnover to $Write_Net_Turnover
print #Net_Turnover (0,{col_turnover_cp}) edit 9999.9
print '%' ()
Below is the forluma used to calculate the Turnover Rate Report (PER101) in EV4.
Turnover Rate[x] = Average # of employees between two dates (Begin Count [d] + End Count [e]/2) divided by (Terminations[a] + Retirements + Transfer Out[c])
move &BeginCountC to #BeginPlusEnd
add #EndCountC to #BeginPlusEnd
if #BeginPlusEnd > 0
! Separations include terminations and retirements
move #TermsC to #Net_Turnover
add &RetireCountC to #Net_Turnover
multiply 200 times #Net_Turnover
divide #BeginPlusEnd into #Net_Turnover
move #Net_Turnover to $Write_Net_Turnover
print #Net_Turnover (0,{col_turnover_cp}) edit 9999.9
print '%' ()