Set Color for Negative Variations

[microwin88x]

Hello,

I have the following expression for the Last Year Variation:

SalesCY / SalesLY - 1

It works perfectly and I use the this expression to set the color:

IF ((SalesCY / SalesLY - 1) > 0, Green(), Red())

The thing is that I have a case where:

SalesCY are -800 and SalesLY are -250

So the Last Year Variation shows me around 220% in Green.

The thing is that it should be in Red, because Current Year (-800) are worse than Last Year (-250).

Is there any way to fix that? (Please note that I have positive values for Sales too, so it should work for both)

Thank you!!!

[m_woolf · Accepted solution]

Maybe just change your expression to set the color:

IF(SalesCY > SalesLY , Green(), Red())