Help with expression (ENUMLIST vs ENUM)

Ms_Margo
Participant II

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 134
2 REPLIES 2

Steve
Participant V

The second argument to IN() must be a list (List or EnumList). An Enum is not a list. Instead of using IN() for [central_activity_type], just use =.

Ms_Margo
Participant II

hanks for the tip! couldn’t get your suggestion to work, but wrapped [_thisrow].[central_activity_type] In a List and it works now
You rock!

Top Labels in this Space