1 Reply Latest reply on Sep 25, 2012 10:16 AM by George_Johnson

    Sum Fields Values Identified by Another Field

    AKNS6600

      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?