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

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

Tue, 17 Mar 2015 18:15:50 GMT

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!

Anonymous — Tue, 17 Mar 2015 18:35:51 GMT

I assume you need help with the background color (or maybe text color) expression for Quantity column. Try this:

if(Quantity=max(total Quantity, rgb(0,255,0)))

Edit: if I got it wrong, upload your app.

Tue, 17 Mar 2015 19:56:13 GMT

Thanks Michael!

Yes, for either the text or the Background color.

I'm going to try this out tonight.

Thanks again!

Anonymous — Tue, 17 Mar 2015 20:27:54 GMT

This rgb looks too light for text. Well, you'll figure out.

JonnyPoole — Wed, 18 Mar 2015 01:00:44 GMT

Are you first summing the quantities from multiple records in your data model to get a by country sum ?

If that is the case I'm wondering if you need aggr() here to first sum() and then get the max of the sums.

if( sum(Quantity)=max(total aggr( sum(Quantity), pays) ), rgb(0,255,0)))