- typemasterfreshAsked 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.
- JotForm SupportBJoannaAnswered 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.
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.
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.