How to calculate totals using Input table fields?

  • Socarb
    Asked on June 20, 2018 at 4:35 AM

    Hello,

    I'm looking for a function to get a sum from different questions.

    I want the numbers filled in to specific questions summed up in a box at the bottom. It is for a sceduling form, and I want the people filling in the form seeing that what they have filled in makes sense and is the right number of hours.

    I also want to calculate within the question, i.e. question 13; I want the number of hours filled in in each box (some will be left blank) to be added in the box "Totalt". And then the numbers from the boxes "Totalt" to be added together in the box "Totalt antal timmar (automatisk uträkning)"

    Thankful for help.

    Ingrid

    Jotform Thread 1503949 Screenshot
  • Kiran Support Team Lead
    Replied on June 20, 2018 at 7:51 AM

    I understand that you want to calculate the total of the fields from an Input table field to the last field and the last fields from different input table fields to be totaled to 'Totalt antal timmar'. 

    In order to calculate the total of the fields from an input table field, you may consider adding a condition as shown in the screencast below:

    15294950111503949 MatrixCalculation Screenshot 10

    For the total of 'Totalt' fields from different Input table fields, you may consider adding a Form calculation widget to the form and add the respective fields to the calculation formula as shown below:

    15294953951503949 MatrixCalculation1 Screenshot 21

    The following guide might help you with more information on performing calculations using Input table fields.

    https://www.jotform.com/help/343-How-to-Perform-Form-Calculation-in-the-Matrix-Field

    Hope this information helps! Please get back to us if you need any further assistance. We will be happy to help.