Add value from Repeating Section

[Marc]

I’ve got a repeating section with a box called Amount, and I would like to
add the amounts from all the entries in the repeating section in a box called
TotalAmounts. Could anyone tell me how to do it?

Thank you

 

[S.Y.M. Wong-A-Ton]

You could add a button with a rule that sets the value of TotalAmounts to the
value of a formula like

sum(Amount)

where "Amount" is the field in your repeating section. Another possibility
is to set the value of TotalAmounts whenever an Amount is filled in. You'll
have to use a helper field for the latter case. I did something similar using
the avg() function. You can check out that solution at:
http://enterprise-solutions.swits.net/infopath/avg-function-infopath.htm.
Instead of avg() you would have to use sum().