In my form, there are many questions, for which the choices are Red, Yellow, Red and N/A. The form is for instructors to assess students, and depending on the question, the instructor may select N/A, meaning that the question is not relevant, and then it should not influence the final result. How can I make that when N/A is selected, it doesn’t affect the final result? I don’t want to give N/A the value 0. I want the values to be Green=100, Yellow=50, Red=0, N/A=not value
Inother words, I want to exclude those N/A values from the average scoring calculations I have set up, by changing the divisor value of my calculation. For example for a field with 5 questions, if one of the included questions is marked as N/A, then I would like to change the divisor from 5 to 4.