Expand my Community achievements bar.

Radically easy to access on brand approved content for distribution and omnichannel performant delivery. AEM Assets Content Hub and Dynamic Media with OpenAPI capabilities is now GA.

Sum Fields Values Identified by Another Field

Avatar

Level 1

Working in LiveCycle ES2. Very basic experience in developing scripting. Have created an expandable Expense Reimbursement form with a replicating table for each expense item (e.g., row). Have a subform at the end of the form to capture the totals.  Have been able to script to capture the AmountSpent for all of the expense items:

form1.MainForm.TotalsSF.Table4.Row2.EmployeeExpenses::calculate - (FormCalc, client)

Sum(ExpenseDetailsTable[*].ExpenseTypeRow.AmountSpent)

Need to script to capture the AmountSpent for only items that are identified as NonReimbursable:

form1.MainForm.TotalsSF.Table4.Row3.NonReimbExpenses

Have a checkbox in the table to identify an expense item as NonReimb.  This box replicates with the table.

form1.MainForm.ExpenseDetailsTable.DetailsLocationRow.NonReimb

How do I script a calculation to sum all of the AmountSpent for each item that is checked as NonReimb?

0 Replies