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?


      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