Count how many times appears a value in a row

[juliaruiz]

Hi!

I've a table named "Responses"
In this table i have 4 columns "User", "Response 1", "Response 2, "Response 3" where there's a enum response (YES or NO)

How I could count how many YES for user adding a Virutal Column

Thank you.

USER                    RESPONSE 1      RESPONSE 2         RESPONSE 3      (VIRTUAL COLUMN)

SAMPLE 1                   YES                        NO                            YES                                2

SAMPLE 2                  NO                           NO                           NO                               0

[Suvrutt_Gurjar · Accepted solution]

Please try

IF([Response 1], 1, 0) +

IF([Response 2], 1, 0) +

IF([Response 3], 1, 0)

This is assuming [Response n] columns are Y/N types.

or please try 

IFS([Response 1]='Yes" 1, [Response 1]="No", 0) +

IFS([Response 2]='Yes" 1, [Response 2]="No", 0) +

IFS([Response 3]='Yes" 1, [Response 3]="No", 0)

This is assuming [Responses n] columns are enum type with "Yes", "No" options.

The summing VC is assumed to be of number type.