2 Replies Latest reply on Nov 14, 2016 8:04 AM by Ramsay Kamal

    Trying to create a calculated field using NULL

    Ramsay Kamal

      Hi all,

       

      I am trying to create a calculated below:

       

      If

      ([VSD Eligible] = "Null" )

      OR

      ([VSD Eligible] <> "Null" AND [Requested VSD Role] = "X")

      THEN "No"

      ELSE "Yes"

      END

       

      I am new to the community, so I will do my best to try and describe what I am requesting. My goal is to create a view in Tableau that looks like this:

       

       

      VSD Rejected List is the calculated field. The highlighted value should be "No".

       

      What would I need to change my formula to achieve the desired result? Or do I need a whole new formula?

       

      Thanks!