- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 73 Insurance
- 537.3K On-Premises Infrastructure
- 138.6K Analytics Software
- 38.6K Application Development Software
- 6K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Fast formula - Absence Entry Validation
According to the client policy, employees are entitled to 3 days marriage leave per employment, the leave could be taken separately 6 months before/on/after date of registration of marriage.
I have created an entry validation formula to check the number of days that have been taken upon absence request submission, if the total taken is more than 3 days, error message will be shown and employees are not able to apply for marriage leave as the entitlement has been used up.
While I found that the no. of day taken of the employee could not be retrieved properly, please refer to the attached file for the created fast formula, I have tried to return the no. of day instead of the error message to further check the problems, it return 51 days which is far more than records that I checked for that employee (7 days). And the validation could not be done.
Would you please advise if there are any problem on the fast formula, thank you.