4 Replies Latest reply on Sep 5, 2018 4:32 AM by Pamela Haas

    Case / If Statement on a Combined Calc Field

    Pamela Haas

      I have a combined field that provides me with an output of "Negative, SIG, -SIG-", which would mean it has a negative significance. I am trying to create a calc that states just that.

       

      I tried this with no luck:

       

      IF ([Combined Field])= 'Negative, SIG, -SIG-')THEN 'Negative Significance'

      ELSEIF ([Combined Field])= 'Positive, SIG, -SIG-' THEN 'Positive Significance'

      ELSE "Not Significant"

      END

       

      I get a message saying I can't combine string and combined fields.

      Any tips?  TIA