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

    Using string with hyphen in it

    Kelly Graham



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



      IF(Age = '<25',


           IF (Age = '25-34',


          IF (Age = '35-50',






      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?