Sum of Sub-question

More
4 years 4 months ago - 4 years 4 months ago #93345 by rodriguezm1
rodriguezm1 created the topic: Sum of Sub-question
Hi, I'm having an issues using the sum() command for a sub-question.

I have an array question, with 10 subquestions, and 6 answers.

the question code is: mode
each sub-question is: sq1 - sq10
and each answer is: a1-a6

On a following question, qcode "multimodal", I first try using the following code:

{if(sum(that.modes.NAOK) > 1, 'more than one', 'irrelevant')}


And it works. My QA checker gives me this:



My issue is that I don't WANT the sum of every possible thing in that question. I only want the sum of sq1. This is giving me the sum of sq1 through sq10.

OK, so I try and adjust the formula to something like this:

{if(sum(that.modes_sq1.NAOK) > 1, 'more than one', 'irrelevant')}


For some reason the code will not work. It won't expand the sum. I get the following in my QA checker


So how come the sum works for the entire question, but not for a sub-question in an array? How can I get this to work the way I want.

Again, I want the sum of the row: modes_sq1
Last Edit: 4 years 4 months ago by rodriguezm1.

Please Log in to join the conversation.

More
4 years 4 months ago #93346 by rodriguezm1
rodriguezm1 replied the topic: Sum of Sub-question
I was able to answer my own question.

Instead of:

{if(sum(that.modes_sq1.NAOK) > 1, 'more than one', 'irrelevant')}

I should have used:

{if(sum(that.modes.sq_sq1.NAOK) > 1, 'more than one', 'irrelevant')}


the "sq" after modes is a reserved term.


So the in general the function would be

Sum(that.questionName.sq_subquestionName.NAOK)

Please Log in to join the conversation.

Did you already participate in our customer survey?

Don't miss your chance for great prices.

Please click here to participate:

Start now

Start now!

Just create your account and start using Limesurvey today.

Register now