Set Color for Negative Variations

microwin88x — Wed, 25 Nov 2020 16:16:04 GMT

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!!!

Re: Set Color for Negative Variations

m_woolf — Tue, 22 Jan 2019 15:34:08 GMT

Maybe just change your expression to set the color:

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