5 Replies Latest reply: Aug 2, 2018 11:48 AM by Kelly Graham RSS

    Using string with hyphen in it

    Kelly Graham

      Hi

       

      I'm trying to set colours on a chart using the following expression:

       

       

      IF(Age = '<25',

           $(vRed),

           IF (Age = '25-34',

           $(vGreen),

          IF (Age = '35-50',

           $(vYellow),

           $(vGrey)

           )

           )

      )


      For some reason I don't think it likes the hyphen in the string ('25-34'). Does anyone have any ideas on how to get around this?


      Thanks!