I am struggling finish a KOBO advance calculation.
there are 5 questions with one selection with 2 or 3 options.
Now I want to auto calculate it. after 5 question are seletected.
Q1:
Option good= 0
Option. bad=1
Q2:
option minor=0
option modarate=1
option severe = 2
so on with different value
What I have been done
calculation 01
if(${Q1}=“1”,1,0)+if(${Q2}=“1”,1,0)+if(${Q3}=“1”,1,0)+ if(${Q5}=“1”,1,0)
calculation 02
if(${Q1}=“0”,1,0)+if(${Q2}=“0”,1,0)+if(${Q3}=“1”,1,0)+ if(${Q5}=“0”,1,0)
calculation 03
if(${Q1}=“0”,1,0)+if(${Q2}=“0”,1,0)+if(${Q3}=“1”,1,0)+ if(${Q5}=“0”,1,0)
total ${cal01}+${cal02}+${cal03}
Now issue is no matter what option I have select, value only adding is 1… 2,3… how to solve it?
