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.
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: