1 Reply Latest reply on Oct 7, 2015 7:04 PM by Douglas Everson

    How to categorize Nulls and if value exists?

    whit.krieng

      This is probably a simple solution for you guys. 

       

      I am trying to create a binomial category of a Customer ID. 

       

      Basically if Customer ID has no value or NULL = '0' and if Customer ID EXISTS then = '1'. 

       

      Do you guys advise an IF THEN or Case statement? 

       

      Thanks for your help.