6 Replies Latest reply: Jul 31, 2014 2:36 AM by Mafaz Jaufer RSS

    How to color column in straight table when value is high or low?

      Hi,

      I have added below query to make "RED" if plan is more than actual and if actual is more than plan "GREEN"

      if(Avg([Plan PSD_FM])> Avg([Actual PSD_FM]),RGB(255,99,71),RGB(50,205,50))

       

      but in 0 its shows "GREEN" I want to make it "WHITE" in 0. please find the image in the attachment