Forum Discussion
MCFNeil
8 years agoQrew Captain
Ideally all of these questions and answers would be child records (which provides much better reporting capabilities), but seeing as you just have the fields...
You will want to make 3 formula fields; # of Yes, # of No, # of N/A.
If the formula you use will be something to the affect of:
Sum(
If([Question 1]="Yes", 1, 0),
If([Question 2]="Yes", 1, 0),
If([Question 3]="Yes", 1, 0)
)
Repeat for all questions, then you can copy it and change the "Yes" to "No" and "N/A".
Now you will have numeric values that you can graph or count for your averages and totals.
You will want to make 3 formula fields; # of Yes, # of No, # of N/A.
If the formula you use will be something to the affect of:
Sum(
If([Question 1]="Yes", 1, 0),
If([Question 2]="Yes", 1, 0),
If([Question 3]="Yes", 1, 0)
)
Repeat for all questions, then you can copy it and change the "Yes" to "No" and "N/A".
Now you will have numeric values that you can graph or count for your averages and totals.