Having trouble calculating a form with 45 rows

  • Profile Image
    ChamplainValleyChorus
    Asked on April 03, 2018 at 12:39 PM

    I'm having trouble calculating two columns of a 45 row matrix. I'm getting really bizarre numbers.


    https://www.jotform.com/help/343-How-to-Perform-Form-Calculation-in-the-Matrix-Field has been helpful, but only for the first 10 rows.

    I need the Group SUBTOTAL field on this form to total up all entries in columns 4 and 5 while ignoring any that are left blank.


    Thank you!

  • Profile Image
    Mike_G
    Answered on April 03, 2018 at 02:19 PM

    Upon checking the form you shared with us from a clone version I see that you have already used a Spreadsheet widget to represent the Group Member Info table in your form.

    However, I still tried to check if I can reproduce the issue you described but I was not able to.

    I removed the Spreadsheet widget from the clone version of your form and replaced it with an Input Table field. Then, I also replaced the Group Subtotal (number field) with a Form Calculation widget.

    Here's the form — https://www.jotform.com/80925555582970

    And here's a screenshot of the result after I have placed the value "1" on every field under the 4th and 5th columns only.

    1522778738t14_02_21.png

    When you add the field to the widget, make sure to only check the checkboxes under the 4th and 5th columns.

    1522778915t14_07_41.png

    Then, add the plus sign (+) after every field added except for the last one.

    1522779301t14_10_12.png

    Also, make sure that the fields in the Form Calculation widget and the plus sign are added as numbers (0-9) and not string (A-Z). Then, save the changes.

    Feel free to clone the form above so you can easily inspect it — How-to-Clone-an-Existing-Form-from-a-URL

    I hope this helps. If you have other questions, please do not hesitate to let us know.