4 Replies Latest reply: Mar 17, 2015 9:00 PM by Jonathan Poole RSS

    Highlight a value in a table, What expression would be best?

    Francois Tremblay

      Thank you Everyone!

       

      Last weekend I've been fighting with my expression to highlight the maximum Quantity amount as showed here:


        

      I would like the Brazil Quantity 3,358,230 to be in green.

       

      I used different expressions:

       

      =if((Max(Quantity), Quantity rgb(0,255,0), Quantity)

      =IF(Sum( {$<Quantity={"<=$(=Max(Quantity))"}>} Quantity),rgb(0,255,0)

      =firstsortedvalue( Quantity, -Aggr(Max([Quantity]),Quantity,rgb(0,255,0)))

       

      Unfortunately none is working! Again maybe my expressions are totally wrong.

       

      Thanks for your advise and insight!