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

    Conditional coloring

    sagarika choudhary

      Hi,

       

      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