Find top number in a dataset

[bob_evan]

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.

[Steve]

help.appsheet.com

MAX()

Highest item in list

help.appsheet.com

MAXROW()

Row with greatest value in column

[bob_evan]

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

[Steve]

Try:

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

[Aleksi]

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

[bob_evan]

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

When I use this it says:

MAX function is used incorrectly

[Steve]

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.