Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

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

Beachbum2015
Level 3
Level 3

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:

https://www.dropbox.com/s/sgsle5bkam2y4am/Expense%20Report%20v1_0%20-%20LC%20Original.pdf?dl=0

Expenses.jpg

1 Accepted Solution
PDFGuru
Correct answer by
Level 4
Level 4

I tried to implement your requirement in the form at following link. Please test it and let me know if it works.

https://www.dropbox.com/s/v4n9kypdnplc857/Expense%20Report%20v1_0%20-%20LC%20Original_V1.pdf?dl=0

View solution in original post

2 Replies
PDFGuru
Correct answer by
Level 4
Level 4

I tried to implement your requirement in the form at following link. Please test it and let me know if it works.

https://www.dropbox.com/s/v4n9kypdnplc857/Expense%20Report%20v1_0%20-%20LC%20Original_V1.pdf?dl=0

View solution in original post

Beachbum2015
Level 3
Level 3

Karan,

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.

Dean