Solved

How do I calculate total from several fields in Infopath form?

Posted on 2009-03-30
2
574 Views
Last Modified: 2012-05-06
Hi,

I am designing an Expenses Report form in Infopath to publish it on Sharepoint. I am trying to calculate total from several fields and want them to automatically sum up in Total field.

I am using Insert Function to set up a fomula but it allows me to brows only one field out of ten. Formula looks like this: sum(../my:travel).

Can somebody tell me how to add other fields and what formula looks like please?

Thank you.
 
0
Comment
Question by:bqamarauli
2 Comments
 
LVL 8

Accepted Solution

by:
MelMc earned 125 total points
ID: 24039710
You can only use sum if all of the fields you are trying to total are in the same node/grouping. If they are not, which it doesn't appear that they are, just set your total field default value to equal field1 + field2 + field3..... + field10 and it will total all the fields for you.
0
 
LVL 1

Author Closing Comment

by:bqamarauli
ID: 31564398
It works fine.

Thank you.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Before you can digitally sign infopath forms, you must have a digital certificate. Microsoft Certificate Services will need to be enabled on a Windows Server 2008 to facilitate the creation and verification of the digital certifciates on the web ser…
Knowing where your website is hosted is as important as the features you receive, the monthly fee, and the support you receive. Due diligence should be done when choosing your next hosting provider.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question