List and in expression not working

[Adam_Grunys]

Hello, would any be able to tell me why this in() expression is returning N.

I cant seem to understand why.

Thanks

[Aleksi]

Is your [role] column an EnumList?

[Adam_Grunys]

Yes it is.

[Aleksi · Accepted solution]

When your [role] column is EnumList, it’s a list already and you should use it like…
IN(…,[role])

[Adam_Grunys]

Right… Thanks so much… Works great!

[Aleksi]

You’re welcome