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

    IF statement as Custom dimension

    Ashley Kuttler

      Hi,

       

      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.