3 Replies Latest reply: Oct 18, 2016 2:59 AM by PAUL YEO RSS

    May i know how make my color display darker color for lowest value ? Now large number color is darker.

    PAUL YEO

      Hi All

       

      Below expression work fine , it display the higher value with dark color :-

       

       

      Colormix1((

       

      $(vPriceBookRatio)

      -$(=min(aggr(

      $(vPriceBookRatio)

      ,COMPETITOR_K))))

      /

      $(=(max(aggr(

      $(vPriceBookRatio)

      , COMPETITOR_K))

      -min(aggr(

      $(vPriceBookRatio)

      , COMPETITOR_K)))),lightgray(),green())

       


       

      Now my requirement have change , the smaller value mean better , so How to change the color sequences the other way round ?


      Paul

       

       

       

      Paul