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

BI Publisher and Person FTE

edited Nov 1, 2018 11:49AM in Reporting and Analytics for HCM 4 comments

Summary

Having issues with FTE in work measures and UNIT

Content

Hi All, I am writing a report and i need to bring back person FTE so i am bring back value and unit from the PER_ASSIGN_WORK_MEASURES_F table and then filtering out so it only brings back unit = 'FTE'

However my problem occurs as we have volunteers who have 0 FTE but need to come back in the report. some of these volunteers have their value as 0 but the unit is HEAD so when i filter to only 'FTE' they don't come back in the report. I tried a CASE WHEN to change the HEAD TO FTE which brings them back but i get another issue in that some part time staff have an FTE and a HEAD so they bring back two lines for their two different values.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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