expression help

[#1]

Hi,

Can anyone help highlight what the expression needs to be to count 'Information Refused', and 'Prefer not to say'. The below expression works individually (i.e Count (if (([Religion]) = 'Information Refused',[Client No])) ) but not when I try and put them together:

Count (if (([Religion]) = 'Information Refused', 'Prefer not to say',[Client No]))

The data is below so the result of the expression should be 596.

Appreciate any help on the expression.

[Gysbert_Wassenaar · Accepted solution]

Try Count (if ([Religion] = 'Information Refused' OR [Religion] 'Prefer not to say',[Client No]))

Or better yet use this: Count ({<[Religion] = {'Information Refused','Prefer not to say'}>} [Client No])

[tamilarasu]

Try,

Count ({<[Religion] = {'Information Refused', 'Prefer not to say'}>}[Client No])

[Chanty4u]

=Count (if{<([Religion] = {'Information Refused'}, or  '{[Prefer not to say] }'>},[Client No]))

[Kushal_Chawda]

Count (if (match([Religion], 'Information Refused', 'Prefer not to say'),[Client No]))

[#6]

We also need to calculate value present, which is all information on religion - 'Information Refused',' Prefer not to say' and 'NULL'. This is the existing expression which works but only currently brings through NULL:

Count (Religion) - Count (if (Religion= 'NULL',[Client No]))

How can expression be amended to bring through all 3 categories?

[Gysbert_Wassenaar]

Just add it to the list: Count ({<[Religion] = {'Information Refused','Prefer not to say','NULL'}[Client No])