10 Replies Latest reply: Sep 28, 2017 5:10 PM by Vijay Vira RSS

    Relative Text Color expression

    Erica Trotter

      Hi,

      is it possible to write a relative text color expression? For example:

      I would like if my expression is 5% below  target it to be red,

      if it is 5% higher or lower than the Target it to be yellow,

      and if it is 5% higher than it to be green.

       

      is this possible? if so how would you write such an expression?

       

      Thanks!