format highest value in a column

AppSheet AppSheet Q&A
, ,
1

This is what I thought would work, but it highlights every value in the column.
Trying to highlight highest value in column using format rule below:

MAX(list([Average])) = [_THISROW].[Average]

2

Try with MAX(YourTableName[Average])=[Average]

1 Like
3

Thank you, this worked. Have a question…
When doing a comparison, what is the significance of A vs B?

A) Max(YourTableName[Average]) = [Average]
B) Max([Average]) = [Average]

Unclear why adding the table name to the evaluation makes a difference in how the evaluation is performed.

4

Max([Average]) reads the “max value” from that row’s column.. which is just one value. The MAX(Table[Column]) reads all rows from a table and picks the maximum value from that specified one column.

1 Like
5

Thanks for clarifying… always considered the difference as shorthand vs longhand… There’s more to it apparently. :slightly_smiling_face:

6

You’re welcome!