General

Re: Getting the sum of multiple fields

witakr — Thu, 10 Feb 2011 00:12:45 GMT

To folks who landed on this thread looking for a solution to this problem.

I lost track of where this thread was so I reposted the question elsewhere.

A solution to this problem can be found on my other thread located here:

http://www.infopathdev.com/forums/p/18318/64057.aspx

Thank you all and sorry for reposting.

Jay

Re: Getting the sum of multiple fields

Jimmy — Mon, 31 Jan 2011 12:02:37 GMT

Is InmateMoney a repeating group, or non-repeating?

Getting the sum of multiple fields

witakr — Mon, 31 Jan 2011 05:38:25 GMT

Hey folks!

Would someone please explain to me how I can get the sum of three fields and display the total in a fourth field?

I have tried under Rules:

sum(GroupName)

but when I click the button "NaN" is the only thing that is displayed.

in my form the user has to enter currency amounts into 3 different fields and then get a total when a button is clicked.

My group and fields are as follows:

Group name: "InmateMoney" which contains three fields: "USCurrency", "USCoinage" and "Checks"

Then a separate field for the total which is named "TOTAL"

When the user enters a number in "USCurrency", "USCoinage" and "Checks" and the user clicks the total button I need the total of the values of "USCurrency", "USCoinage" and "Checks" to be calculated and displayed in the "TOTAL" field

I hope I didn't confuse anyone.

Thank you in advance for any help!

Jay