Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Can you close all your opened thread, it will be helpful for others who is having similar issue. Thanks
Since we are listing out all possible ways to do this, here is another one
If(StoreName Like 'Derm*, 'Enterprise', 'Joint Venture')