Skip to main content
Participant
October 20, 2021
Question

Need a script for conditional Sum in Form calc

  • October 20, 2021
  • 3 replies
  • 360 views

I have a requirement as below.

The table has one header and two rows, one row is for repeating the Items in the transactions, and the other one is to display the total.

There is a field called Document Type, and when the value of this field is "Customer Invoice" and  "credit Memo," then the total should be summed up from the field Original Amount.

The total should calculate in the next row.

I have tried multiple scripts; unfortunately, nothing works.

 

Path for Document Type FormTradeReceivablesPayablesAccountStatementNotification.bdyPage1.frmTableBlock.tblOpenItemTable.rowOpenItems.coltxtTransaction

Original Amount

FormTradeReceivablesPayablesAccountStatementNotification.bdyPage1.frmTableBlock.tblOpenItemTable.rowOpenItems.coldecAmount

Total

FormTradeReceivablesPayablesAccountStatementNotification.bdyPage1.frmTableBlock.tblOpenItemTable.rowFooterRow.colCell5

 

Please refer to the below table for a better understanding.

Item NoProductDocument TypeOriginal Amount
10ACustomer Invoice100
20BPayment20
30CCredit Memo50
40DClearings-10
  Total150

 

Thanks.

    This topic has been closed for replies.

    3 replies

    Bernd Alheit
    Community Expert
    Community Expert
    October 21, 2021

    Is this a Designer form?

    Raji5C2EAuthor
    Participant
    October 21, 2021

    Hi, 

     

    Apologies, this is Adobe LiveCycle designer.

     

    Thanks.

    Nancy OShea
    Community Expert
    Community Expert
    October 21, 2021

    LiveCycle is integrated in Adobe Experience Manger Forms now.  That's on another product community platform below.

    https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager-forms/ct-p/adobe-experience-manager-forms-community

     

     

     

    Nancy O'Shea— Product User & Community Expert
    Nancy OShea
    Community Expert
    Community Expert
    October 21, 2021

    [Moderator moved from Using the Community (forums) to Acrobat Pro discussion.]


    Nancy O'Shea— Product User & Community Expert
    Peru Bob
    Community Expert
    Community Expert
    October 20, 2021

    This is the Using the Community forum (which is the forum for issues using the forums).
    Please tell us what Adobe application you are using so that this can be moved to the proper forum for help.