Calculate a field based on how many questions have been answered "yes"

40
1
07-29-2019 01:20 PM
Highlighted
New Contributor III

Hello,

I have a survey with a series of yes/no questions, the  user needs to know at the end how many questions have been answered  "yes". Is there a way to do this? 

Reply
0 Kudos
1 Reply
Highlighted
Frequent Contributor II

You need to make a second calculate field and then use a if(field=yes,1,0).  Then make sure to set the bind::type column to int.

Then your final one would be field1count + field2count + ...

Yep its is a pain if you have lots of fields.