Hi everyone,
I have a group of questions containing a few yes/no questions, which are dependent on the previous question. Once a question group has been answered I should get a list of suggestions ranging from A - F. Once all group questions have been answered I would like to calculate which answers have been suggested the most and be able to pass on a result based on that.
I am able to show the answers to a group of questions by using if(selected(${question, 'Yes'), 'Yes', 'No') and the relevant field, but I don't seem to be able to calculate this. When using calculations it seems to add all the questions instead of just the selected questions of that group.
See example below, where bold defines the answer given.
I hope this makes sense.
Thanks so much in advance.
Question 1 | | | | | | A | B | C | D | E |
Yes: | Question 1.1 | | | | | | | | | |
| Yes: | Questions 1.1.1 | | | | | | | | |
| | Yes: | | | | 1 | 1 | 1 | 1 | 1 | |
| | No: | | | | 1 | 1 | 1 | 0 | 0 | |
| No: | | | | | 1 | 0 | 0 | 0 | 0 | |
No: | Questions 1.2 | | | | | | | | | |
| Yes: | | | | | 1 | 1 | 0 | 0 | 1 | |
| No: | | | | | 1 | 0 | 0 | 0 | 0 | |
| | | | | | | | | | | |
Question 2 | | | | | | | | | | |
Yes: | Question 2.1 | | | | | | | | | |
| Yes: | Questions 2.1.1 | | | | | | | | |
| | Yes: | | | | 1 | 1 | 1 | 1 | 1 | |
| | No: | | | | 1 | 1 | 1 | 0 | 1 | |
| No: | | | | | 1 | 1 | 0 | 0 | 0 | |
No: | Questions 2.2 | | | | | | | | | |
| Yes: | | | | | 1 | 1 | 1 | 0 | 1 | |
| No: | | | | | 1 | 0 | 0 | 0 | 0 | |
| | | | | | | | | | | |
| | | | | | | | | | | |
| | | | | Total | 2 | 1 | 1 | 1 | 1 | |