Sub totals from Value List
We have a script in a record that is used to log production hours. Each record can have multiple people listed. The script is made up of several Value Lists. The two that concern me are the Name and Hrs lists.
We have a total Hrs field at the bottom of the Hrs list. What we would like to do is break down the total Hrs into sub totals for each person in the Name list. The Names list can have any number of different people or just one person.
Is there a way to create a sub total of Hrs for each individual in the Names value list?
I've inlcluded screen shots of the Script in Brows and Layout mode.