Getting the sum of multiple fields - InfoPath Dev
in

InfoPath Dev

Getting the sum of multiple fields

Last post 02-09-2011 04:12 PM by witakr. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 01-30-2011 09:38 PM

    Getting the sum of multiple fields

     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

     

  • 01-31-2011 04:02 AM In reply to

    Re: Getting the sum of multiple fields

    Is InmateMoney a repeating group, or non-repeating?

    Jimmy Rishe / Software Developer / Microsoft MVP
    Qdabra Software
  • 02-09-2011 04:12 PM In reply to

    Re: Getting the sum of multiple fields

     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

Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.