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?

      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!