Generate Leave Quota Based on Previous Year Attendance

Dear Experts,

My client is required to generate a leave quota based on the previous year's attendance but there is one condition if an employee is on unpaid leave for the full month then the quota should not be generated for the specific month.

I.E. Every month's quota should be 1.417 so when we execute the quota next year in January then 12 x 1.417 = 17

If an employee is absent for 3 months, that case quota should be 17 - 3 x 1.417 = 12.75

Absence & Absence Quota configuration is done.

Please help me with PCR and the correct place where I can put the PCR into Schema.