How to loop a structure in Adobe Livecycle designer changing the invoice form

[orestis_x]

Dear all,

I am trying to sum the total of downpayments that are listed in the invoice and print at specific place were the customer has asked.

In the interface of the invoice I am receiving the below and i need to sum all DueItems that have Type Code = 2.

I have created a subform binded with DueItem[*], created 2 fields, one text and one decimal binded with the two fields. I have added an if statement checking for the type code and adding the netvalue, but it doesn't seem to work.

Do I need to bind to a table for this to work?

Any ideas?

Thank you,