11 Replies Latest reply: Dec 28, 2017 3:40 AM by Sunny Talwar RSS

    IF statement as Custom dimension

    Ashley Kuttler



      I have a group of store locations.. I need to identify as either "Joint Venture" or "Enterprise" in my charts.


      I have a custom dimension with the following expression:


      =IF(StoreName = 'Derm 1' or

      'Derm 3' or 'Derm 4', 'Enterprise', 'Joint Venture')

      But it only picks up 'Derm 1' as  Enterprise and not the other two. What am I missing?

      Thanks in advance.