Expand my Community achievements bar.

Calculation Add to A Specific Subtotal Based on Drop Drown

Avatar

Level 4

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 

0 Replies