Expand my Community achievements bar.

July 31st AEM Gems Webinar: Elevate your AEM development to master the integration of private GitHub repositories within AEM Cloud Manager.
SOLVED

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

Avatar

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

Avatar

Correct answer by
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

Avatar

Correct answer by
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

Avatar

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