Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
BI Publisher and Person FTE
Summary
Having issues with FTE in work measures and UNITContent
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:
0