Hello
I need to check whether the answers to Qu1 is coherent with the answer in Qu7. It is coherent if is the opposite (A in Qu1 and B in Qu7 or B in Qu1 and A in Qu7 ).
The questions 1 and 7 are of array type, with one subquestion (choice between "Option AX" and "Option BX", with X=1 or 7).
To do so, I have set-up a question of type "equation" in the group of questions where I have question 7.
Given that I have 8 versions of the questionnaire (8 blocks), I have 16 conditions in my equation.
I want the response to this question to be 1 if the answers are coherent and 0 otherwise.
My problem: When I answer to the questionnaire, I don't see any value in the column corresponding to this coherence question. Can you see an error in the equation?
{if(Block1Qu1[SQ001]=='Option A1' and Block1Qu7[SQ001]=='Option B7', 1,
if(Block2Qu1[SQ001]=='Option A1' and Block2Qu7[SQ001]=='Option B7', 1,
if(Block3Qu1[SQ001]=='Option A1' and Block3Qu7[SQ001]=='Option B7', 1,
if(Block4Qu1[SQ001]=='Option A1' and Block4Qu7[SQ001]=='Option B7', 1,
if(Block5Qu1[SQ001]=='Option A1' and Block5Qu7[SQ001]=='Option B7', 1,
if(Block6Qu1[SQ001]=='Option A1' and Block6Qu7[SQ001]=='Option B7', 1,
if(Block7Qu1[SQ001]=='Option A1' and Block7Qu7[SQ001]=='Option B7', 1,
if(Block8Qu1[SQ001]=='Option A1' and Block8Qu7[SQ001]=='Option B7', 1,
if(Block1Qu1[SQ001]=='Option B1' and Block1Qu7[SQ001]=='Option A7', 1,
if(Block2Qu1[SQ001]=='Option B1' and Block2Qu7[SQ001]=='Option A7', 1,
if(Block3Qu1[SQ001]=='Option B1' and Block3Qu7[SQ001]=='Option A7', 1,
if(Block4Qu1[SQ001]=='Option B1' and Block4Qu7[SQ001]=='Option A7', 1,
if(Block5Qu1[SQ001]=='Option B1' and Block5Qu7[SQ001]=='Option A7', 1,
if(Block6Qu1[SQ001]=='Option B1' and Block6Qu7[SQ001]=='Option A7', 1,
if(Block7Qu1[SQ001]=='Option B1' and Block7Qu7[SQ001]=='Option A7', 1,
if(Block8Qu1[SQ001]=='Option B1' and Block8Qu7[SQ001]=='Option A7', 1, 0
))))))))))))))))}
Many thanks in advance for your help
The topic has been locked.
