3 Replies Latest reply: May 14, 2015 3:00 AM by KALYAN KRISHNA RSS

    Conditional Coloring of Text in a Text Box. (make negatives red)

      Text Box Display Formula: Expression using the contents of two other text boxes

      Font Color Formula: IF (Expression > 0, green, red)

      I use this method in my dashboard but it means that the entire expression has to be copied into the Font Color formula.  The issues I have with this are:

      1) Doesn't this affect performance because the formula has to be calculated twice? Once for the expression to be displayed in the text box and once for the text color?

      2) Is there a way of referring to other calculations in other text boxes like you can in a Table Box.  I have found that changes have been made to the expression that displays but those changes were not put into the color formula also.  It would be nice if there was a "Current Expression Value" function or the ability to refer to another object like you can with a column.  ie. if [Budget] - [Sales] >0, green, red.  That way any changes in the Budget calculation would then be seen by the font color expression.  Any ideas?