2 Replies Latest reply on Sep 1, 2018 2:43 PM by Shinichiro Murakami

    Custom color coding include consider nearest round values as well

    rao marapatla

      Hi All,

       

      I have scenario which I need to show green and red  while showing green have to consider nearest round value as well

       

      attached workbook(v10.5) please help me :

       

      if [ measure 1(with nearest round) ] > [measure 2]

      then 'Green'

      ELSEIF [ measure 1(with nearest round) ] < [measure 2]

      then 'Red'

      END

       

      thanks