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

Tip: Looking for answers? Try searching our database.

Formula question

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bryan - 05 Jan 2006 23:54 GMT
I have a form for employees mileage logs.
I can sum the total miles but I need to sum each entry. See  -
www.bojik.com/formula.pdf for a sample of the form.
S.Y.M. Wong-A-Ton - 06 Jan 2006 15:09 GMT
Hi,

It's not clear to me what your current challenge is. You could use
expression boxes to do the summing across rows as well as columns in a
repeating table.

Regards,
S.Y.M. Wong-A-Ton

> I have a form for employees mileage logs.
> I can sum the total miles but I need to sum each entry. See  -
> www.bojik.com/formula.pdf for a sample of the form.
Bryan - 06 Jan 2006 15:25 GMT
S.Y.M.,

I am not trying to sum accross the rows.  I need to get the difference of
"startOd and EndOd" on each row so I need to subtract not add.  I will then
sum the "Total Miles" at the bottom with a sum formula.

Also is there a way to do a sumif statement in infopath?  Once I get the
above problem worked out I need to sum the "Total Miles" column by each Job #.

Bryan

> Hi,
>
[quoted text clipped - 8 lines]
> > I can sum the total miles but I need to sum each entry. See  -
> > www.bojik.com/formula.pdf for a sample of the form.
S.Y.M. Wong-A-Ton - 06 Jan 2006 19:39 GMT
Hi,

You can also use an expression box to subtract. Try converting the total
miles field to an expression box, then enter the following formula: StartOd -
EndOd
where StartOd and EndOd are the fields in your table. Also make sure that
StartOd and EndOd are of a numeric type (whole number or decimal) and not
text. You can change this through the properties dialog box of the
corresponding fields in your form's data source.

I don't believe you can do a sumif without using custom code. Have a look at
the Expense Report sample form that comes with InfoPath. It contains code to
do additions in a repeating table.

Hope this helps.

Regards,
S.Y.M. Wong-A-Ton

> S.Y.M.,
>
[quoted text clipped - 19 lines]
> > > I can sum the total miles but I need to sum each entry. See  -
> > > www.bojik.com/formula.pdf for a sample of the form.
 
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.