1 Reply Latest reply: Aug 15, 2012 8:09 AM by Stefan Wühl RSS

    Text in chart expression help

    Chris Hopkins

      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?