Solved

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

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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…
Make the most of your online learning experience.
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

687 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