-
SocarbAsked 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
-
Kiran Support Team LeadReplied 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:
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:
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.