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.
How to add a count column for employees aligned to a job in OTBI.
Summary:
I have created a report in OTBI to show all job names in our business. I need to create a column which does a count on the number of employees who have this job in myHR. I need this to exclude Inactive employees and also count jobs which no employees are aligned too. When I used the below measure it done the count as I wanted but also removed around 2.5k jobs from my report where previously they were showing. Is there a better way to do the case? Thank you for your help!
I've added the full XML for detail. Thank you.
Tagged:
0