Text in chart expression help

[hopkinsc]

Hi,

I have the following expression as 'Text in Chart'

=num($(vGrossSalesYTD)-$(vCancellationsYTD))-num($(vGrossSalesPTD) - $(vCancellationsPTD))

I want the background of the text to go red if the result is a negative.

Can anyone help me on how to do this using a calculated background please?

[swuehl · Accepted solution]

Use calculated Base color in your Color area dialog:

=if(

num($(vGrossSalesYTD)-$(vCancellationsYTD))-num($(vGrossSalesPTD) - $(vCancellationsPTD)) < 0,

,lightred()

)