2 Replies Latest reply on Nov 28, 2016 9:18 AM by Stephen Hellyar

    Combined Field Without Nulls

    Stephen Hellyar

      I have 2 dimensions that should be one.  So, I want to consolidate them. 

      Both are text fields. 

      Each field contains a Null where the other one contains a value.

       

      So if Dimension 1 is Dog.  Dimension 2 is Null.  If Dimension 2 is CAT.  Dimension 1 is Null. 

       

      I created a simple calculation.

       

      [Dimension 1]+[Dimension 2]

       

      But using the Dog and Cat example the result looks like:

       

      DogNull

      NullCat

       

      How do I get the calculation to ignore the Nulls and print the result?

       

      Dog

      Cat. 

       

      Combined Field does not solve this.  It generates


      Dog, Null

      Null, Cat