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

      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?