3 Replies Latest reply on Sep 22, 2016 9:20 AM by Toby Erkson

    IsNull with if statements

    Garima Vohra

      Hi,

       

      I have a data set in which one of the columns has null values, which I intend to mark as blank. I used IfNull to achieve that in a calculated field. I have another column with not applicable entered in 2 formats - NA and N/A. I want to make it N/A in the entire column. What I am struggling with is- I got the first task done using If Null but when I tried adding more if statements under the If null, tableau is giving errors. Do I need 2 calculated fields to do it, if yes how? If it can be done in a single field as I tried, I got "may be you are missing an operator error". I know it can be done in excel but I am sure it can be done with tableau. Waiting for your inputs and suggestions.Thanks in advance.