Solved

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

Posted on 2009-03-30
2
576 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

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…
After hours on line I found a solution which pointed to the inherited Active Directory permissions . You have to give/allow permissions to the "Exchange trusted subsystem" for the user in the Active Directory...

734 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