automatic boot the maximum value by text classification

[ADEFE_EUROPA]

Hello dear experts. I need to write an automatic boot the maximum value by text classification with the following expression:

It turns out that it is writing me only the lowest value in text classification. please i ask for help

ANY(SORT(SELECT(Confirmação de Pagamento da Anuidade[Exercício],
[Email]=[_THISROW].[Email],FALSE

))FALSE)

[Aurelien · Accepted solution]

Hi @ADEFE_EUROPA 

What about this ?

ANY(
  TOP(
    SORT(
      SELECT(Confirmação de Pagamento da Anuidade[Exercício],
         [Email]=[_THISROW].[Email]
      ),
      TRUE
    ),1
  )
)

For reference:

SORT() - AppSheet Help

TOP() - AppSheet Help

ANY() - AppSheet Help

[ADEFE_EUROPA]

Thank you dear Aurelien, I will try right now

[ADEFE_EUROPA]

MUCHAS gracias Aurelien!!!!!

Ha funcionado muy bien!!! Gracias

[Sara_Bertomeu]

Hi ADEFE EUROPA:

Try with: 

MAX

MAX(list)

Highest item in a list. Learn more

List

TOP

TOP(list, how-many)

Initial list of items. Learn more

if not search on it: https://support.google.com/appsheet/table/10104782?hl=en&ref_topic=10099895,10173496,10099316,

Sara

[ADEFE_EUROPA]

Thank you dear Sara, but I think that essa is not good for text.
List of any numeric or any temporal type