Cumulative Turnover

kaiossantana — Thu, 26 Jul 2018 19:05:21 GMT

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

Re: Cumulative Turnover

dwforest — Wed, 01 Aug 2018 18:12:31 GMT

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)

Re: Cumulative Turnover

hubertdudek — Wed, 01 Aug 2018 20:39:32 GMT

Try to use Above with offset

topic Re: Cumulative Turnover in App Development

Cumulative Turnover

Re: Cumulative Turnover

Re: Cumulative Turnover