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

    formula for differentially coloring text fields

    Ralph Lindenfeld



      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?