If else scripting error

[niha]

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

[Vegar · Accepted solution]

Try this expression:

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