Is there any way available to get absence count for a given Plan in a given duration
I am trying to write a fast formula to get absence count for given Absence Plan(not type) in a given duration to address one of our requirement.
Appreciate if someone can help me on this.
In our environment, we have defined two Plans:
- Annual Vacation (Accrual Type)
- Unpaid Vacation(No entitlement)
We have attached both these plans to following absence type:
Here Annual Vacation is priority 1 and Unpaid Vacation is priority 2.
Now following is the scenario:
- Employee has 15 days Annual Vacation Balance as on 01-Apr-2023
- Employee applies for Absence Type: Vacation "StartDate: 01-Apr-2023 till 15-May-2023" (45 days)