How do I add a summary page that displays the totals based on categories from dropdown list?

[jeffm70816839]

How do I add a summary page that displays the totals based on categories from dropdown list? I created a dynamic voucher that can expand to many pages and would like to display a summary page that rolls up the totals for the different expense codes (1-Housing, 2-Medical, 3-Transportation)? So, really two questions how to add a summary page different from the main form, and how to write the java to calculate the totals from the form to populate on the summary page.

[lateniteNC]

I did a form that sounds very similar - it has several expandable tables on the first four pages and a summary page on page 5.

Here is a link to that file: https://www.dropbox.com/s/rnkouipscnfvigc/Revised%20NCDOT%20Emergency%20Assistance%20Invoice.pdf?dl=...

Dropbox - Revised NCDOT Emergency Assistance Invoice.pdf

See if that provides some guidance. It is a relatively simple matter to insert some Formcalc code to copy the results from the first several sections and assign that value to the summary table.

[jeffm70816839]

That helped answer adding the summary page, the second part I believe will require java because I only have one expanding table that has a column with expense code categories that I need to "filter" totals for each of the codes. Can Formcalc query Thanks for the help.

[radzmar]

The solution in this thread is what you're looking for.

expanding table sumif inside an expanding table

[jeffm70816839 · Accepted solution]

I figured it out, got busy and didn't get back to post. Here is what I came up with

Here is the Summary Page where the JS is inserted into each of the total fields and modify the ExpenseCodeValue and the Items.Row(number) and Total(name) for each category

And here is a shot of the main form where the query runs

Hope this save someone else some time figuring this out.