Calculating Certain Fields in Matrix

  • Profile Image
    RogerYelvington01
    Asked on April 06, 2015 at 09:54 AM

    Hey Guys!

    On this form: http://form.jotformpro.com/form/50416867039965

    I need to accomplish 4 calculations that use the 10 "Membership Sold" input box fields:

    1.  Down Payment Total Calculation:
    I need for the "$ Down Payment" field to be added up from all 10 boxes and calculated at a summary in the bottom.

    2.  Member Contract Total Calculation:
    I need the "$ Contract Total" field to be added up from all 10 boxes and calculated at a summary in the bottom.

    3.  $ Dues Rate, Average Calculation:
    I need the "$ Dues Rate" field to be averaged from all 10 boxes and calculated at a summary in the bottom.

    4.  # Member Term, Average Calculation:
    I need the "#Member Term" field to be averaged from all 10 boxes and calculated at a summary in the bottom.

     

    This is so important to our process, and I am trying to present this form to my managers this afternoon.  Any help is appreciated, thank you very much!

  • Profile Image
    Charlie
    Answered on April 06, 2015 at 11:19 AM

    Hi,

    Unfortunately, you can't fetch or update certain fields in the Matrix field. What I would recommend is that you convert those fields into simple or plain text boxes. With that, you can pass the value and sum them all up.

    You can then use the Form Calculation widget to sum up all the text boxes with values on them. Here's a guide on that: http://www.jotform.com/help/259-How-to-perform-calculation-in-the-form.

    Do let us know if you need more help on this.

    Kind regards.

  • Profile Image
    Charlie
    Answered on April 06, 2015 at 11:30 AM

    Hi again,

    If you have received multiple email notification from this reply post, please do accept our apologies, we had a temporary hiccup on the server that posted the replies multiple times. 

    Again, apologies for the inconvenience.