4 Replies Latest reply on Oct 23, 2018 2:31 PM by Zach DiSalvo

    IF Else Calculated field w/ String dimension and date dimension

    Zach  DiSalvo

      Is it possible to create a calculated field that works with two different demensions: a string and a date field. I am creating the calculated field for the purpose of creating a colored legend based on 2 different dimensions. below is how i think it should look...

       

      IF [String Dimension] = 'yes' THEN [String dimension]

       

      ELSEIF [String Dimension] = 'no' THEN [Date dimension]

       

      END

       

       

      I'm getting an error when i try this. another way i tired is below...

       

      IF [String Dimension] = 'yes' THEN 'yes'

       

      ELSEIF [String Dimension] = 'no' THEN [Date dimension]

       

      END

       

      Any thoughts on how to make this work? data is sensitive so i can't provide a sample. Thanks!