Count the instances of "Yes" (in a row) across 5 specific columns

Evening,

Please could someone show me where I’m going wrong with this?

I’m trying to count the instances of “Yes” (in a row) across 5 specific columns.

I have the following in VC but I’m not getting the right result.

COUNT(SELECT(survey[branch_A_decision], [THISROW].[branch_A_decision] = “Yes”))+
COUNT(SELECT(survey[branch_B_decision],[_THISROW].[branch_B_decision] = “Yes”))+
COUNT(SELECT(survey[branch_C_decision],[_THISROW].[branch_C_decision] = “Yes”))+
COUNT(SELECT(survey[branch_D_decision],[_THISROW].[branch_D_decision] = “Yes”))+
COUNT(SELECT(survey[branch_E_decision],[_THISROW].[branch_E_decision] = “Yes”))

I had a look at the posts below but couldn’t convert them.

Thanks in advance… :slight_smile:

Try:

(
  IFS(([branch_A_decision] = "Yes"), 1),
  + IFS(([branch_B_decision] = "Yes"), 1),
  + IFS(([branch_C_decision] = "Yes"), 1),
  + IFS(([branch_D_decision] = "Yes"), 1),
  + IFS(([branch_E_decision] = "Yes"), 1)
)
5 Likes

Hi @Steve,

That works! Thank you very much!

:+1:

1 Like

I love IFS()… :heart_eyes:… it makes formulas so clean.
:nerd_face:

3 Likes