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

    Text in chart expression help

    Chris Hopkins



      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?