I have 2 repeating tables. Table 1 lists Employees and their Payrate. Table 2 has a dropdown field called Name that gets its values from the Employee field in table 1, a text field called Task, a Rate field that looks up the employee's payrate, a number field called Hours, and a Cost field that multiplies Rate by Hours.
Table 1 looks like this:
Employee Payrate
John 50
Jane 75
Mark 35
Table 2 looks like this:
Name Task Rate Hours Cost
Jane Design the form 75 4 300
Jane Test the fields 75 1 75
John Review the form 50 3 150
Jane Publish the form 75 1 75
I would like to list the total number of hours of tasks for each employee in another table. So I copied Table 1, placed it further down the form, and removed the Payrate field, leaving just a list of the Employee Names. I tried creating another field in Table 1 called Hours Tasked, but I cant figure out a way to total the hours for each user. I tried to use this formula
sum(Hours[Name=Employee]) I have also tried reversing Name and Employee
Yhis is the result I get:
Name Hours Tasked
John 9
Jane 9
Mark 9
I would like the table to look like this:
Name Hours Tasked
John 3
Jane 6
Mark 0