Hi all,

I'm having trouble with the "sumifop" function, similar to this old (unresolved) issue: www.limesurvey.org/forum/design-issues/94333-sumifop

In short, I want to get the sum of the scores of radio list questions, but only those scores greater than zero.

I created an equation question with the following:
{sumifop(">", 0, B1.valueNAOK, B2.valueNAOK)}

If I select the answer for B1 that gives me a score of 1000, and the answer for B2 that gives me a score of 1000, I get:
"010001000" instead of the sum of the two scores, 2000.
It appears to be correctly selecting the answers I want, but instead of adding them as values, it is joining them into a string.

If I use {sum(B1.valueNAOK, B2.valueNAOK)}, it works just fine, but obviously isn't filtering for the scores greater than zero.

Any suggestions? I'm stumped.

Thanks,
Megan

What if you don't use "NAOK"?

Thanks for writing back!

No change.

Which version of LS are you using and can you provide a .lss file that only contains the questions relevant for this problem so we can test?

Version 2.57.1+161205

Attached is one group of questions from the survey, where I've been doing my testing. Eventually I need to implement it for the whole survey (>150 Qs).

Thanks so much.

Not sure where sumifop comes into play with these two questions?

It's a bug - I can reproduce it in 2.6.2.

Please file a bug report - bugs.limesurvey.org/

The JavaScript is seeing the values as strings instead of numbers, so concatenating them instead of adding them.

As a workaround, try something like this:

Will do. Thanks for the confirmation and the workaround!

But please : fill a bug report , think it's linked with github.com/LimeSurvey/LimeSurvey/commit/...c77aef09fd4c48e73b7d

Yeah, probably. I don't know whether that's causing problems elsewhere but it seems sumifop could be be easily fixed by using Number(arg) in function LEMsumifop(). (untested)

Yes, but still : if we need to add Number(arg) each time we use a new function ......

Yes, I know, that's why I said it's not necessarily a global fix.