Need help in Absence entry validation formula

Summary

Need help in Absence entry validation formula

Content

Hello All,

 

We are using below absence entry validation formula to restrict absence to certain days in a year. It is working fine except one case where we are trying to update the same absence and reducing the duration

 

For Ex.

 

If I applied leave for 4 days  then my L_Total_Duration = 4

Now when I am trying to update the same leave and reducing the duration from 4 to 3 it is calculating L_Total_Duration = 4(Earlier duration)+3 = 7 which is greater than 5 and as per the condition in code it is giving me the error.