IF statement as Custom dimension

[akuttler]

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.

[devarasu07]

Hi,

Can you close all your opened thread, it will be helpful for others who is having similar issue. Thanks

[sunny_talwar]

Since we are listing out all possible ways to do this, here is another one

If(StoreName Like 'Derm*, 'Enterprise', 'Joint Venture')