How do i do average calculations for matrix tables per row?

  • Profile Image
    acellenceresearch
    Asked on August 14, 2017 at 01:38 AM

    Hi,

    I will like to calculate the average rating per row based on the number of people who responded in the survey. I have enclosed a screenshot of the table and the survey link (qn 8).

    Example:

    5 people selected rating 2 for Serving speed, 2 selected rating 5. The Average will be [(5 x 2) + (2 x 5)] / 7 = 2.85].

     

    I will like to calculate the average rating per row in the matrix table. Is there a way to calculate this? I'm not sure how to use the form calculation widget for this.

    Thanks!

     

     

  • Profile Image
    Kiran
    Answered on August 14, 2017 at 02:48 AM

    Since you want to calculate the average of different submissions, you may calculate it using Excel by exporting the submissions to Excel. However, you may assign the calculation values (only numbers) in the matrix field so that the submission data can store the calculation value.

    If you want to perform calculations for the matrix field to display on the form itself which works for that particular submission, you may follow the steps in the guide below:

    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.