Yes/No Evaluation with [EnumList][EnumList] Expression Vs Virtual Column

[Markus_Malessa]

I have the following expression:

AND([Report_Category] = "Calendar Year Total", IN("IRR_GW", [WR_Number][BU Codes]))

which evaluates to FALSE. For proof of concept I created a VC as follows:

Then replaced the expression like this:

AND([Report_Category] = "Calendar Year Total", IN("IRR_GW", [PermitBUCodes]))

which evaluates to TRUE.

I am already straining the limits of Appsheet in my opinion with VCs, so I really was hoping to not add another VC and just handle this inside the expression. Anyone have any suggestions why the 1st expression doesn't evaluate to TRUE? The column [WR_Number] is of type EnumList(Ref) and [BU Codes] is of type EnumList(Text). I already tried using LIST([WR_Number][BU Codes]) but that didn't work either.

[Suvrutt_Gurjar · Accepted solution]

Could you try 

AND([Report_Category] = "Calendar Year Total", IN("IRR_GW", SPLIT([WR_Number][BU Codes],",")))

[Markus_Malessa]

Thank you. That did the trick. I had not considered SPLIT() simply because I thought the expression would have already considered this to be a LIST.