Ir al contenido
Menú
Se marcó esta pregunta

I am trying to create a salary rule that does the following:

For every Sunday that falls between the payslip dates, count the hours worked on the previous 7 days (mon-sun). For each check, if the total is more than 40, subtract 40 to get the weekly overtime hours; else, make 0, or disregard. Sum all results and multiply by ( contract.hourly_wage * 2 ) to get the final result.

This should give the total number of hour worked over 40 hours in each calendar week that finished in this pay period.

If anyone can help or at least point me in the right direction, I'd be so grateful!

Avatar
Descartar
Publicaciones relacionadas Respuestas Vistas Actividad
1
ene 24
1962
2
may 23
7971
1
oct 19
5029
0
ene 17
4063
0
may 23
4069