2 Replies Latest reply on Jan 22, 2010 11:46 AM by scholarform07

    Total specific fields for a Total Field

    scholarform07

      I am creating an application for a scholarship and there is a section for financial information asking for annual income of parent, spouse, etc.

      At the bottom of the form I have a feild for the total amount of parent, spouse, etc. Each feild has a different name. How do I get the Total Feild to total the previous fields?

        • 1. Re: Total specific fields for a Total Field
          pguerett Level 6

          On the Total Field write javascript on the Calculate event that will add each of the individual fields up. You will want to use the fieldname.rawvalue to get the value of the field back. The formula would look something like this:

           

          this.rawValue = Field1.rawValue + field2.rawValue + .......

           

           

          Paul

          • 2. Re: Total specific fields for a Total Field
            scholarform07 Level 1

            Thanks Paul for your answer. I have

            a problem.

            1st. I typed the script in for the first four fields and everything worked fine. I cleared what I typed in and started over typing in the rest of the fields and the caculated feild would not show anything. I cleared out again and typed: this.rawValue=   and then I held down ctrl and clicked on the first field then typed .rawValue+ and clicked on the next feild and so on till I got to the 7th feild then this is what it started doing:

             

            this.rawValue=ExAssisSchYr.rawValue+ExpdAssisForYear.rawValue+ExpdAssisForYearPrts.rawValu e+ExpdAssisForYearOther.rawValue+SchoolLoans.rawValue+Scholarship1.rawValue+xfa.resolveNode("Scholarship2[1]")

             


            I highlighted the problem blue. There are a total of 12 feilds that need to be totaled.

             

            Thanks

            Michael