List and in expression not working

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

I cant seem to understand why.


Is your [role] column an EnumList?

Yes it is.

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

Right… Thanks so much… Works great!

You’re welcome