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?
None.
Both column type are Decimal.
Ok, post the formula youโre using
[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)
Perfect.
Solve.
Thanks
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |