Count the number of employees per FTE — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Count the number of employees per FTE

edited Nov 12, 2018 4:35PM in Reporting and Analytics for HCM 6 comments

Summary

Report which present the number of the employees per FTE

Content

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!!

 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!