Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Cumulative Turnover
Good afternoon,
I tried several formulas to get the cumulative Turnover index (RangeSum (above, Aggr, Sum and others, but nothing, see if they can answer this question:
Formula used:
(Admitted + Off) / 2 / Total employees = Turnover
QS formula:
(Count (if (Status = 'Off_Month'and ([Position] <>' Apprentice ') and ([Position] <>' Intern ', [ID collaborator]))
+
Count (if (Status = 'Admitted'and ([Position] <> 'Apprentice') and ([Position] <> 'Intern',[ID collaborator])))
/2/
(Count (if (Status = 'Active'and ([Position] <> 'Apprentice') and ([Position] <> 'Intern', [ID collaborator])))
The point is to accumulate the months
Jan - 2.07%
Feb - 2.57%
Sea - 1,75%
Accumulated should be> 6.39%
Thank you
Mensagem editada por: Kaio Santana
Not sure why you have /2 in there -- should be just: (Admitted + Off) / Total employees
If this is not working in a chart/graph by month, try adding an aggr
aggr(sum((Admitted + Off) ), MonthField) / Aggr(Sum(Total employees), MonthField)
Try to use Above with offset