Manipulating List-User information for calculations
I have a list-user field called Tech Recipient, it's for a maintenance company build. Tech stands for technician.
Per job, users are entered into this field to show who did a job. Also on this form, we capture total hours for the job. What I am trying to do is create a summary report that tells me how many hours each technician did (we billed for) per week, based the Tech Recipient field vs. how many hours the job took.
For example, "John Doe" is a tech, and "Adam Smith" is a tech. They both worked on a job, and were listed under the Tech Recipient (list-user) field. Both are users on the application. Further down in the form there is a numerical field reading that job took 8 hours.
I have created a new field (Formula-numeric) to try and figure this out. All formula attempts have failed. Any suggestions?
------------------------------
Jeff Nixon
------------------------------
Per job, users are entered into this field to show who did a job. Also on this form, we capture total hours for the job. What I am trying to do is create a summary report that tells me how many hours each technician did (we billed for) per week, based the Tech Recipient field vs. how many hours the job took.
For example, "John Doe" is a tech, and "Adam Smith" is a tech. They both worked on a job, and were listed under the Tech Recipient (list-user) field. Both are users on the application. Further down in the form there is a numerical field reading that job took 8 hours.
I have created a new field (Formula-numeric) to try and figure this out. All formula attempts have failed. Any suggestions?
------------------------------
Jeff Nixon
------------------------------
