error: cannot compare list with Yes/no

[DaGi07]

Hi guys, 

how can i avoid this errors? 

The column [Koros] is type yes/no and i would ectract the result from table CERCA_ODOO. If the koros field is yes, then I want to do one thing, otherwise another. I tried with ANY() but it doesn't works.

Tks guys

[1minManager]

I don't think [Koros] is just a Yes/No.  Have you set it to an EMUNLIST type column?  Also is this the formula's in a ENUMLIST column?

[DaGi07]

@1minManager Column Koros:

 The column where i set this expression is type "percent" because i have to obatin numeric value introducing other math expression but these compute must change IF Koros is true or false...

[1minManager]

Try IF([Koros]=TRUE,1,0) just to see if this errors

[TeeSee1]

Where is this expression written?

If it is within the table CERCA_0000, you do not need CERCA_0000.

If outside CERCA_0000, then CERCA_0000[Koros] gives you the entire values (a list) of the column. ANY will most likely give you the first value and assume that is not what you want.

Or bot??

Community members need more info to support you better.