Count the number of employees per FTE

Nov 12, 2018 4:35PM

Summary

Report which present the number of the employees per FTE

Hi,

We tried to create an analysis that count the number of the employees per FTE (Full-Time Equivalent).

For example:

20 employees - 0.4

150 employees - 0.8

452 employees - 1

(attached please find an example of expected result).

For some reason, I couldn't manage to do it via the OTBI (I guess with a simple sql it would be - count the person_number and group by the FTE).

Does someone have an idea how to do that via the OTBI?

Thanks!!