IF expression per line - KPIS

[Oz_73]

Hello everyone

I have a table (imported from Excel) where I want to set background color (green, yellow, red), depending of comparission of 2 cells, i.e. if measure from B field is >= to A should be green but not all rows have the same criteria of comparission, what will be the best approach / statemente or function to compare every row accordingly?

Thanks

[G3S]

In the script you could have a new field which calculates the comparison, then set the background colour based on the values in the new field.

[Rams- · Accepted solution]

Hi,

In table properties you have background color expression textbox, you have to put your condition in that textbox. As shown below

Below is my background color expression:

Below is my result table:

Hope this helps,

help user find answers ! don't forget to mark  a solution that work for you and click the like button!

[Oz_73]

Thank you very much Rams-, that works.