Holiday Statutory pay calculation
My calculation is not working for the holiday pay. What I am trying to do is take the employee total hours for a certain time period (find between two dates which will be four weeks of hours) and then calculate those hours ex: 188 hours and divide this by 20 days. It should come out as 9.40 which the employee will be paid for that stat holiday. However, it is calculating as .55.
My calculation is "employee_total_hours/20
Employee_total_hours is a calculating field.
Would appreciate any help on this.