Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
niha
Creator II
Creator II

If else scripting error

Hello,

I am having error from this ststements. I am trying to create a dimension bigcountry having the below country. Please suggest.

if (
( Country = ('Italy', 'France', 'Spain', 'United Kingdom')),1,0) as Bigcountry,

Regards,

Niha

Labels (1)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

Try this expression:

if(match(Country,'Italy', 'France', 'Spain', 'United Kingdom'),1,0) as Bigcountry,

View solution in original post

1 Reply
Vegar
MVP
MVP

Try this expression:

if(match(Country,'Italy', 'France', 'Spain', 'United Kingdom'),1,0) as Bigcountry,