Count of a choice from numerous select_one question

[ÉmilieBerthiaume]

Hi,

In my survey, I have a repeat on plant species for which I have two select_one questions: Is it a dominant plant (answer yes or no) and what is the "statut" (it's french for "status"...) of this plant (answer: OBL, FACH or NI).

I want to count the number of dominant plants for which the "statut" is OBL or FACH, and the number of plants for which the status is "NI"

Based on what I understood form this page: https://support.esri.com/en/technical-article/000021063

I have tried the following: 

It is not working...  Could anybody suggest a way to acheive this?

Thanks!

Émilie

[DougBrowning · Accepted solution]

You do not want your numbers to be text so just 1 instead of '1'.  Then in the bind type column set it to int.  (Also note you can set bind esri type to null then they wont show up in the data)

Also set them to calculate type not hidden, works better.

That should so it.

[ÉmilieBerthiaume]

Thanks, it worked!

I ended up changing a little bit my formula like this:

And it did exactely what I wanted.  Thanks a lot for your help on this,

Émilie