7 Replies Latest reply: May 19, 2016 7:38 AM by sagarika choudhary RSS

    Conditional coloring



      I wish to add conditional coloring in my profile but it isn't working


      I have two measures in my KPI and I want one measure to be red when it is less than the other measure and if it is greater than it should appear as green.


      I am using this code.

      if((Avg([Option Trd Cnt15 nnn]) < Avg([Option Trd Cnt14 nnn])), red(), green())


      Kindly help