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


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.
Who is Participating?
MelMcConnect With a Mentor Commented:
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.
bqamarauliAuthor Commented:
It works fine.

Thank you.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.