Hi! I have had a good luck around and found a few threads that begin to explore this. But nothing that seems clear to my beginners level of knowledge. I hope readers will forgive my newbie ignorance.

I have a number of groups of questions (varying number of questions per group) but all questions are 'List with Comment' type (drop down presentation).



All questions have the same answers (1-5) and I have assigned assessment values to them.

A1 100 Gold
A2 66 Silver
A3 33 Bronze
A4 0 Fail
A5 0 N/A

For each group I have added an expression. And I can average the group, no problem. If I hard code the number group questions.

Where there are 4 questions in the group...

(which gives me a percentage)

But obviously this doesn't give a correct average if a user selects answer 5 for 1 or more questions.

I know I need to return the number of group questions (count?) but I am unsure how to do this How do I achieve this?

Thanks.

Max

Try this:

Thanks! The 'if's' worked out perfectly.