I’ve researched some old topics but haven’t quite found the solution I need. I have a situation where there are different services and the pay rate for each service varies based on the employee who is performing it. Example:

Service 1: Jane Doe is paid $20, John Smith is paid $25

Service 2: Jane Doe is paid $30, John Smith is paid $35

Service 3: Jane Doe is paid $40, John Smith is paid $45

I’m using a Form for the employee completes some services. Also, there may be more than one service submitted for each job. Example:

1/20/22: Jane Doe submits an entry for Service 1

1/22/22: John Smith submits an entry for Service 1 AND Service 3

1/22/22: Jane Doe submits an entry for Service 1 AND Service 3

I want to be able to roll up the employees total pay rate for these entries. Based on the above example my rolled up value for the work done would be:

1/20/22 by Jane would be $20

1/22/22 by John would be $70

1/22/22 by Jane would be $60

I’m using a Single Select field to associate all of these against payroll weeks so that I can group the weeks and see what the total pay should be for each person.

Hope this makes sense.

Thanks!