How to sum numeric fields based on a value in a text field - Expense Report



I'm working on an employee Weekly Expense Report that contains a list of expense amounts, and each can be marked as a company or employee paid expense.  There are two fields on the form that need to show the totals for Company and Employee paid expenses.  There are seven columns for amounts, one for each day of the week.  The Expense Code text fields are called "Exp1" through "Exp7".  The Amount numeric fields are called "Amount1" through "Amount7".  The fields under each column share the same name.  (Hope that makes sense).  A screen shot is below, and a link to the form is included to better understand the makeup of the form.  I'm not sure how to go about totaling up all expenses marked with a "C" and all of those marked with an "E".  I'm not well versed in Java.  Any suggestions would be greatly appreciated!  Thanks!!

Link to form:


Answers (1)

Answers (1)




Your solution works great!

Thank you very much for taking the time and effort to help me resolve this challenge.  That's exactly what I needed.