Trying to create a formula that pulls various hourly rate information from another table and calculates the hours x hourly rates into a grand total field. Additionally, rates vary depending on the employee selected, so once a name is selected, the formula will pull their respective rates from the other table and start the calculation. I believe this may require a roll up field as well, but not sure where that falls in the flow.
Here’s a screen shot of the other table with various $$$ rates
Here’s my main timesheet table where you’ll see a number of hour totals (Reg., OT, and 2xOT).
Again, once I choose a name (People) I want to calculate those totals with their respective rates in the Total Compensation field.
Really stuck on this one!