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 can I calculate Absence Sickness for Employees for 4 absences of 3 days or more?
Summary:
I need to produce a report for employees that have had more than 4 sickness absences of 3 days or more within a rolling 12 month period.
I have managed to create a report that picks up more than 4 absences for a rolling 12 months but not sure how to calculate where each absence has been over 3 days.
Could anyone help with my query?
Thanks
Mark
Content (required):
Subject Area - Workforce Management - Absence Real Time.
For this employee I want to calculate total and produce a single line rather than 5.
No of Absences (in this case 5).
No of Absences where duration is more than 3 (in this case it would be 4).
Tagged:
0