4 Replies Latest reply: Jan 8, 2013 10:06 PM by Barry Sarcich RSS

    Can you reference the value of an expression in Background Color properity

    Ben Laubach

      I'd like to avoid re-writing an expression as part of the background color statement for said expression.

       

      For example

       

      Expression =  Sum(A)/Sum(B)

      Background Color = if( Value_of_Expression > A, Green(),

                                    if( Value_of_Expression > B, Yellow(), Red() ) )

       

       

      Replacing "Value_of_Expression" with the actual expression works, but it's difficult to maintend for complicated expressions.

       

      Do alternative methods exist?

       

       

      Thanks,

      Ben