Colors in straight table based on expressions

[#1]

Hi all,

I have a straight table and I want a column to get a color based on an espression:

column "Valore unitario" has to become yellow when the value is lower than the espression max(total Importo/Quantita) , i.e. the value is lower than the maximum value in the column.

The max value in the column in 0,1380.   So all the values below that level should be yellow.   In this case on the contrary I get some cells with maximum value 0,1380 that become yellow. Can anyone tell me why?

Please see attached file.

Thank you.

[Gysbert_Wassenaar · Accepted solution]

Could be a rounding issue. If Importo isn't exactly 1.738,80 but 1.738,999999...etc then the result of division by 12.600 isn't exactly 0,1380 but 0,137999999...etc