Calculations based on yes_no response

Question

#yes-no‌

I need to make some calculations based on yes_no responses.  The questions are inside a set of repeats where the user gathers plant data from multiple plants along multiple transects.  At the end, for all plants selected 'yes', I need the total number of plants recorded and the total number of "bites" on those plants.  The following statement generates an error stating 'if' requires 3 arguments and only 2 provided.

if(selected(${yes_no},'yes'),sum(${countbites}))

Once I get this figured out, I will do the same with the number of plants recorded 'yes' and divide the numbers.  I'm sure there is a long calculation that can do this all at once, but for now, this will do.

JamesTedrick · Answer

Hi Jimmy,

This is best done by having the calculation in the repeat section and then summing at the end.   I've attached a sample that does something similar - count the number fo children in the repeat section.  You do the number calculation in the repeat section based on yes/no, and then sum at the end.

Resrvations_Workshop.xlsx

JimmyErnst1 · Answer

After entering some data, I notice the total bites only appears when I choose a species and then select yes.  If I select no, nothing is displayed.

Ex.  Species 1 - 'no' - 3 bites =  nothing displayed

Species 2 - 'yes' - 0 bites = 3 displayed

Species 3 - 'yes' - 4 bites = 7 displayed

Species 4 - 'no' = 5 bites = nothing displayed

Trying to learn this on my own with nothing more than GeoNet and the website.

JimmyErnst1 · Answer

That syntax still gives me the total # of bites, including 'no' responses.  Do I need another statement at the end where you have ""?    I need to do this for both yes and no answers but I need to do it separately.