Calculate section scores and show results on thank you page

  • Profile Image
    typemasterfresh
    Asked on March 22, 2018 at 02:19 PM

    I have a questionnaire and it is in multiple sections. Each section will have several Scale Rating questions. I want the form to take the average of all the answers in each section and show some text depending on what the average is. For example: the person completes Section A and the average in that section is 2.1 (based on their Scale Rating entries). The average for Section B is 3.4 (based on their Scale Rating entries).

    On the Thank You page, I want it to show something like:

    Your rating for Section A is:  POOR

    Your rating for Section B is:  NEEDS IMPROVEMENT

    I am having 2 problems:

    1) I cannot get the Form Calc widget to work even when I use the instructions here: https://www.jotform.com/answers/445163-Calculate-average-from-scale-ratings

    It shows the numbers that were entered, not the calculated average.

    2) On the conditional logic, I can only get it to show one text (eg. Section A's rating). I can't see how to make it show multiple results.

  • Profile Image
    BJoanna
    Answered on March 22, 2018 at 03:45 PM

    You did not set correctly your avgNoZero() calculation. The fields have to be separated by a comma, like this. 

    1521746750calc.JPG

    Here is my demo form: https://form.jotform.com/80806288586975 

    Feel free to test it and clone it

    Regarding your Thank You page conditions. There is a possible conflict because both conditions can be true. 

    1521747260condition2.JPG

    I would suggest you to use a single Thank You page, you do not have to use conditions, and show the result of both score fields there. 


    For example, you can add the field "Your Section A Results" on the Thank You page. 

    1521747723TY.JPG

    Setting up the Thank You Page