Create a expresion in Format Rule

Luiso_Ferrandiz · 11-23-2021 02:56 AM

Hi all,
I am trying to create a format rule, comparing two columns in different tables.

If data in in table1[col1] > data in table2[col1] apply the format.
Both data are decimal

but it gives me an error “Cannot compare Decimal with List in …”

Any clue? Thanks.

1minManager

Is one if these and ENUMLIST type column?

Luiso_Ferrandiz

None.
Both column type are Decimal.

1minManager

Ok, post the formula you’re using

Luiso_Ferrandiz

[L2] > Filtro[Target Time f]

Filtro = Tablet
[L2] =Column in Data base (call Datos)
[Target Time f] = Column in Data base (call Filtro)

1minManager

Will produce a list. Its the same a saying

Select(Filtro[Target Time f],TRUE)

So you need to limit it by enclosing it with ANY(), MAX(), MIN() etc. Or if there is always only ever 1 item in there try:

INDEX(Filtro[Target Time f],1)

Luiso_Ferrandiz

Perfect.
Solve.

Thanks