I have built a survey with fifteen different " select_one" questions

BrendanMoore

I have built a survey with fifteen different " select_one" questions with the answers being either yes, no, or N/A. I want to add a new field to my survey that sums the number of 'no' answers from the 15 questions. Is this possible and can you show any examples? 

thank you,

Brendan

NickDierks1

There might be a more elegant solution to this, but this will work: start by adding 15 more questions, all hidden and null. Each of those hidden questions will have a calculation like if(selected(${Q1}, 'no'), '1', '0'). Then you have one more field that adds each of those together.

Note that hidden types are treated as text, so you should use the int() function to treat their values as numbers in the calculation!

type	name	calculation	bind::esri:fieldType
select_one yes_no	Q1
hidden	Q1Boolean	if(selected(${Q1}, 'no'), '1', '0')	null
select_one yes_no	Q2
hidden	Q2Boolean	if(selected(${Q2}, 'no'), '1', '0')	null
select_one yes_no	Q3
hidden	Q3Boolean	if(selected(${Q3}, 'no'), '1', '0')	null
select_one yes_no	Q4
hidden	Q4Boolean	if(selected(${Q4}, 'no'), '1', '0')	null
text	TotalNo	int(${Q1Boolean}) + int(${Q2Boolean}) + int(${Q3Boolean}) + int(${Q4Boolean})