0 Replies Latest reply on Jun 9, 2011 3:18 PM by ParreLaws

    Calculation Add to A Specific Subtotal Based on Drop Drown

    ParreLaws Level 1

      I have for dynamic form with repeating fields.  There are three subtotals one for each sales person (that do not repeat). I would like to add the sum for each sales person from the "Sales" field depending on which sales person is selected in the "SalesPerson" drop down field. Please note that these are not in tables, but just Text, Drop Down and Numeric fields lined up like a table.

       

      Example:

                          TotalSales

      Jill                    35

      Bobby              20

      Mike                 30

           Total            85

       

       

      Sales Person     Sales

      Jill                       10

      Mike                    20

      Jill                       10

      Jill                       15

      Bobby                  20

      Mike                    10