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:





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





      Combined Field does not solve this.  It generates

      Dog, Null

      Null, Cat