automatic boot the maximum value by text classification

AppSheet AppSheet Q&A
,
1

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)

1 Like
2

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

2 Likes
3

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

1 Like
4

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

5

Thank you dear Aurelien, I will try right now

6

MUCHAS gracias Aurelien!!!

Ha funcionado muy bien!!! Gracias

2 Likes