Table and Value List

[Matthew R White]

I have a table that shows expenses, it has 2 fields one field is the amount (number field) the other field is whose expense it it, (text field) and the whose expense is a drop down menu with 2 selections which are Scott or Matt.

How do I set up a calculation that calculates all of the records with the drop down Matt selected, and vice versa all the records with Scott selected.

Thanks

[Fitch]

I can think of several different approaches. For example:

Expenses.zip

[Matthew R White]

You are awesome!!