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

Tip: Looking for answers? Try searching our database.

Problems with formula

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Janie - 30 Jun 2006 14:26 GMT
I have a row of fields in a repeating table.  Here is the layout:

Field 1  Field 2  Field 3 Field 4 Field 5  Field 6
 %          %        #        #        #       Total

I want to sum fields 3, 4 & 5 and then multiply them by field 1 and then
multiply all of that by field 2.  The formula I'm using works, but only if
you fill out both fields 1 and 2.  Sometimes, we don't want to put anything
in fields 1 or 2, but we still want fields 3-5 to be summed in the total
field.

This is the formula I'm using in the "total" field.  How can I adjust it so
that it works even when there are no values in fields 1 or 2?  Or just a
value in field 1, but not field 2, etc?

((field3 + field 4 + field 6) * field1) * field2
Greg Collins [InfoPath MVP] - 30 Jun 2006 21:00 GMT
You will probably have to write code to set the total value. The problem is that if the field is blank, it thinks that it is a zero.
With that in mind, then of course the total won't work if the % fields are blank.

Signature

Greg Collins [Microsoft MVP]
Visit Brain Trove ( http://www.BrainTrove.com )
Visit InfoPathDev ( 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.