2 Replies Latest reply: Jul 14, 2016 11:19 AM by Rodrigo Cotelo RSS

    Conditional Colors positive and negative variance values

    Rodrigo Cotelo

      Hello,

       

      I wonder if someone could help as I've given up with this one after hours playing with it.

       

      I'm trying to have a tables shoe red values if a variance percentage value is above 25% or below -25%.

       

      I've tried with the following example without success:

       

      if($(hotel_spend_avg_ytd_yoy)<-0.25,RGB (170,57,57),RGB(87,149,50)),

      if($(hotel_spend_avg_ytd_yoy)>0.25,RGB(170,57,57),RGB(87,149,50))

       

      When I try either of those individually they work with the expected behavior just fine. When stringed together the formula says "OK" but neither color appear.

       

      Any insight/help you can provide me with will be greatly appreciated!