Hello LimeSurvey World! I need some help.

Using an array I can easily sum up the assessment scores using an equation field. But how do I come up with a percentage score if we have a "no Answer" column?

For instance, if we have 2 rows with a 1 to 5 score and the person picked a 5 for each answer then the score would be 10/10. BUT, what if the person picked a 5 and a "No Answer" (which in my case means not applicable) then the true score would be 5/5 not 5/10.

I need to dynamically, using an equation, calculate the denominator. Help Please!


p.s. My 3rd grader will be so happy that I used the word denominator in a sentence