Create a expresion in Format Rule

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.

Is one if these and ENUMLIST type column?

1 Like

None.
Both column type are Decimal.

Ok, post the formula you’re using

1 Like

[L2] > Filtro[Target Time f]

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

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)
2 Likes

Perfect.
Solve.

Thanks

2 Likes