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 2008

Tip: Looking for answers? Try searching our database.

Sum Columns

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Steve 2008 22 - 14 Jan 2008 22:50 GMT
I am creating a repeating table in my form. I have 2 main fields one called
'unit price' and the another called 'quantity'. I have created a expression
box in the table which multiples the quantity by the price to give me a total
price for each line added. I am wanting to add a further box which will sum
up all of the total prices. However I have done everthing I know and it wont
allow me to do this as it does not recognise the expression box as a field. I
know it is possible because microsoft have a template with a similar table.
Are there any experts out there who can help me resolve this problem.

Thanks
Clay Fox - 15 Jan 2008 01:40 GMT
Hey Steve.

You would not be able to use the sum field since it is an expression and not
a field.

Since your quantity and price vary per line you can not sum each and multiply.

The only way I coudl see it working is if you only had a set number of rows
each time and you could manually calculate it but this is probably not
realistic.

I would add a total field to your repeating table.
You can have an expression that references a field so just because it is an
expression box it does not mean there is not a field.  Otherwise design the
MS template and see how they do it.

Another possible option would be to have a running total field.  So as each
line was totaled it would add the new amount to the running total.  That
could work if they would not be deleting rows.

Signature

Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

> I am creating a repeating table in my form. I have 2 main fields one called
> 'unit price' and the another called 'quantity'. I have created a expression
[quoted text clipped - 6 lines]
>
> Thanks
 
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.