Solved

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

Posted on 2009-03-30
2
573 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

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…
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

911 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now