Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / March 2006

Tip: Looking for answers? Try searching our database.

Add value from Repeating Section

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Marc - 13 Mar 2006 20:10 GMT
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 - 14 Mar 2006 08:43 GMT
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().
---
S.Y.M. Wong-A-Ton

> 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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.