Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!!
Maybe just change your expression to set the color:
IF(SalesCY > SalesLY , Green(), Red())
Maybe just change your expression to set the color:
IF(SalesCY > SalesLY , Green(), Red())