Find top number in a dataset

Hi,

I am wondering how appsheet can find the top number in a table.

I have a table sales rep and profit made. How can I identify the employee who has the most profit in his column.


1 Like

Or maybe just sorting the order directly on a view (Sorting) and selecting “Descending”.

What I am trying to do is make a format rule that’ll put an icon next to the top value in the column. Not sure how to use max() or maxrow() to do this

Try:

([column-name] = MAX(table-name[column-name]))
1 Like

([GROSS PROFIT] = MAX(“Stats & Pay”[GROSS PROFIT]))

When I use this it says:

MAX function is used incorrectly

Table names cannot be quoted in that context, and the & in the table name is going to be a problem all over the place. You should rename the table so it does not have the & in it.