You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Is there any way available to get absence count for a given Plan in a given duration

Received Response

Hi Experts

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.

Business Case:

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:

  • Vacation

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)

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!