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 / September 2005

Tip: Looking for answers? Try searching our database.

problem getting a grand total - am i missing a f(x) feature?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
kase - 20 Sep 2005 07:32 GMT
everyone seems to have the same problem. I'm doing a simple invoice. i have a
quantity and a price in a repeating table. I want to have a subtotal in the
same row and then a grand total at the bottom that adds all the subtotals.

1.
I've tried having the subtotal as an expression box but then i can't get a
grand total. Is there a way to sum expression box?

2.
The solution everyone is suggestion on this forum is to leave the subtotal
as a text box. Click the button next to value that lets me enter a function.
I DON'T HAVE A BUTTON anywhere in properties that lets me enter a function
into a text box. I have InfoPath 2003. Do I have an older version? Do I need
to turn on some feature? What can I do?
Greg Collins [InfoPath MVP] - 20 Sep 2005 21:03 GMT
2. Sounds as though you need to upgrade to Office SP1. There are a ton of extra features in SP1 that should make development life easier for you.

1. This has been discussed numerous times in this newsgroup. I don't have the answer immediately available for you, but can tell you it involves the "eval()" function. You should be able to find it doing a search in Google Groups.

Signature

Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com

everyone seems to have the same problem. I'm doing a simple invoice. i have a
quantity and a price in a repeating table. I want to have a subtotal in the
same row and then a grand total at the bottom that adds all the subtotals.

1.
I've tried having the subtotal as an expression box but then i can't get a
grand total. Is there a way to sum expression box?

2.
The solution everyone is suggestion on this forum is to leave the subtotal
as a text box. Click the button next to value that lets me enter a function.
I DON'T HAVE A BUTTON anywhere in properties that lets me enter a function
into a text box. I have InfoPath 2003. Do I have an older version? Do I need
to turn on some feature? What can I do?
 
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.