Calculating results in matrix field.

  • Profile Image
    eaga
    Asked on September 26, 2016 at 04:13 PM

    Hello. For my form called:

     

    Judging Form - Most Inspiring - Sculptured Cake Artist

     

    How to i calculate the total for each category into one column on the far right.

    I want to calculate the total score given for each person.

     

     

  • Profile Image
    david
    Answered on September 26, 2016 at 06:46 PM

    If you would like for your options to have values, you can assign them calculation values:

    https://www.jotform.com/help/301-How-to-Assign-Calculation-Value

    Those values or any other numerical values in the form, can be totaled up in a calculation field:

    https://www.jotform.com/help/301-How-to-Assign-Calculation-Value

  • Profile Image
    eaga
    Answered on September 26, 2016 at 07:46 PM
    But I don't understand what it is saying.
    ...
  • Profile Image
    Chriistian
    Answered on September 26, 2016 at 11:28 PM

    It looks like you are using a Matrix field for your "Judging Form - Most Inspiring - Sculptured Cake Artist" form. If I understand correctly, you want to calculate the total for each row in the matrix into a new column? 

    You will need to use a Form Calculation widget for each of the rows that you want to calculate. To do so, please follow this guide: How to Perform Form Calculation in the Matrix Field?

    Here's a demo that you can check out and clone to your accounthttps://form.jotform.com/62698847110968. Please note the demo only calculates the total of the first row in the matrix (Berna Garcia).

    Please let us know if you need further assistance.
    Regards.

  • Profile Image
    eaga
    Answered on September 27, 2016 at 10:46 AM
    Thank you for the information but how to I put the total into a new column next to the last column?

    ...
  • Profile Image
    Chriistian
    Answered on September 27, 2016 at 12:15 PM

    If you want the add a new column on your Matrix field that computes the total for each row, unfortunately, Matrix Field is not capable of doing calculations per row. As a workaround, you can try to use the Spreadsheet widget instead of using the Matrix field. 

    You can check this demo form so you can see how the Spreadsheet widget works: https://form.jotform.com/61441655557965.