Global Absence Accrual Matrix
In this article we will talk about Global Absence Accrual Matrix fast formula and see how this formula can be used to calculate absence accrual and also prorate the same if there are any changes in the assignment record. Before we process further lets understand what is the business requirement.
Learn With the Example
Before we write our formula lets understand what is the business requirement
- If workers job contains ‘Sales’ or ‘Director’, they should receive 3 days of accrual every month.
- If workers job doesn’t contains ‘Sales’ or ‘Director’ and workers Normal Working hours is less than 37.5 hours per week, they should receive 2 days of accrual every month.
- If workers job doesn’t contains ‘Sales’ or ‘Director’ and workers Normal Working hours is equal to or more than 37.5 hours per week, they should receive 2.5 days of accrual every month.
- If worker has applied for any unpaid leave, they wont be receiving accrual for that period. Accrual should be deducted and adjusted in the plan.
- If there is any change in the workers job, normal working hours or FTE, they should receive prorated accruals.
Write Global Absence Accrual Matrix Formula
To write fast formula navigate to Setup And Maintenance » Task Panel » Search » Fast Formulas
Subscribe Now to Unlock Premium Content!
Choose a plan that fits your needs and stay ahead in your career with our expertly curated premium content.
Login if you have purchased