Help with expression (ENUMLIST vs ENUM)

Hi All - I think my brain might be mush…. I have an expression that is working well and trying to apply it to another slice but i am getting an error:
Parameter 2 of function IN is of the wrong type

Working expression:
IN(

ANY(

SELECT(team[subteam],USEREMAIL()=[email])),

SELECT(central_category[central_category_groups],in([central_category_name],[_thisrow].[central_category])))

Expression giving an error:

IN(

ANY(

SELECT(team[team],USEREMAIL()=[email])),

SELECT(central_activity_type[central_activity_type_group],in([central_activity_type_name],[_thisrow].[central_activity_type]))))

The only issue is that [central_sub_category] is an ENUMLIST where [central_activity_type] is a ENUM.

Any ideas?

0 2 142
2 REPLIES 2
Top Labels in this Space