1 Reply Latest reply on Sep 27, 2012 2:07 PM by Tracy Rodgers

    formula for differentially coloring text fields

    Ralph Lindenfeld

      Folks-

       

      I'm trying to differentially color fields based on individual field characteristics.

       

      Right now it's displaying red/green depending on whether CUSTOMER change has been positive or negative:

       

      (ZN(SUM([Customers])) - LOOKUP(ZN(SUM([Customers])), FIRST())) / ABS(LOOKUP(ZN(SUM([Customers])), FIRST()))

       

      However, I'd like to code the individual fields based on whether CUSTOMERS, POPULATION, or ASSETS/CUSTOMERS has had a positive or negative change. (see attached image).

       

      I tried a CASE statement, and an IF, but get errors.

       

      Can anyone help?

       

      Thanks,

       

      Ralph