I'm not completely sure but have your tried
ELSEIF IsNull([Do Not Call] = TRUE
then " "
I think working with that should lead to an answer. Otherwise you are always welcome to upload the workbook and I can have a look.
Hope it helps. If does please mark it as helpful so other users can refer to it. Thanks!
You may also try this
Use INT(NULL) in ELSE part instead of zero (0) and remove the ZN() from calculation and check. See the below screenshot for one calculated field.
SUM(IF [Do not call] = 'Yes' then 1 else INT(NULL) END) /
SUM(IF [Do not call] = 'Yes' then 1
ELSEIF [Do not call] = 'No' then 1 else INT(NULL) END)
Hope this will help.
Good Morning Mahfooj,
Thanks for giving this a shot. I tried and it does work but the n/a situation for Medical Privacy gets messed up. I need to show to n/a if the entire column has nothing but n/a.
I tried this as well but I need all my scenarios to work as described in the original question. Somehow if one works then the other doesn't.
Thanks for giving this a shot. As described in my original post, I have different scenarios and if one works then the other doesn't.