I have a series of 15 numeric 0/1 questions, named c760a-c760o.
Then there are two other questions q1 and q2, and which one is asked depends on the response to the earlier question.
If the sum of c760a-c760o is 0, q1 and q2 should be skipped. If the sum of c760a-c760o is 1, then q1 should be asked. If the sum of c760a-c760o is greater than 1, than q2 should be asked.
I've done this format for the skip logic
c760a + c760b + c760c + c760d + c760e + c760f + c760g + c760h + c760i + c760j + c760k + c760l + c760m + c760n + c760o = 1
When c760a-c760o contain all 0/1 responses, than the skip patterns work fine. But when even one of the variables c760a-c760o is coded as -999, my refuse code, the skips are thrown off.
For example if the sum of c760a-760o is greater than 1, even if there is a missing value, then q2 comes up, which is correct. However if my sum of c760a-760o is 1, but one or more of c760a-c760o is coded as -999, then q1 is skipped and q2 is asked instead, which is not what I want.
I feel like the missing code may be being treated as a numeric value when I'm doing these sums. Is there any way to prevent that, or any other way I may be able to solve this issue involving refuse values?
I've also tried doing skips using jquery, and they're running into the same issues working with all 0/1 responses, but not if there are missing values.
Thanks so much!