Cumulative Turnover

[kaiossantana]

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

[dwforest]

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)

[hubertdudek]

Try to use Above with offset