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 / May 2006

Tip: Looking for answers? Try searching our database.

Sum Expression Box

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rich Q - 17 May 2006 18:37 GMT
Forgive the newbie question.  I have a series of data in a repeating table ,
with a subfolder in InfoPath. The subfolder contains numeric data, the
broader repeating table folder has an alpha-only box. Effectively, it looks
like this.
<Text field> <number1> <number2> <number3>...<number13>.

After <number13>, I need to sum the numbers, but cannot seem to get the sum.

ANy ideas?
Greg Collins [InfoPath MVP] - 22 May 2006 20:09 GMT
It looks like each number is a column (not row) in your repeating table.

Suming a one column across multiple rows is easy: sum(Column)

Someone might have an easier way that this, but as far as I know, suming multiple columns in a single row needs to be done this way, without sum():

Number1 + Number2 + . . . Number13

Signature

Greg Collins [Microsoft MVP]
Visit Brain Trove ( http://www.BrainTrove.com )
Visit InfoPath Dev ( http://www.InfoPathDev.com )

 
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.