Im building a Payroll Form view which is calculating Employee’s HOURS by DATE. (pulled from ORDERS table. )
And it has different Payment RATES depending on the amount of Hours worked during the day…
They get payed 100% first 8 hours.
They get payed 125% the next two hours (8-10 h)
The get payed 150% the NEXT two hours (10-12 h)
The get payed 150% IF it is saturday.
I’ve managed to pull the Total Hours in between two dates with a virtual columns and the Saturday hours…
And now im trying to pull out the hours devided by the Payment Rates during the day.
Any tips on how can i acheive my goal ?