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)
Solved! Go to Solution.
What about this ?
ANY(
TOP(
SORT(
SELECT(Confirmaรงรฃo de Pagamento da Anuidade[Exercรญcio],
[Email]=[_THISROW].[Email]
),
TRUE
),1
)
)
For reference:
What about this ?
ANY(
TOP(
SORT(
SELECT(Confirmaรงรฃo de Pagamento da Anuidade[Exercรญcio],
[Email]=[_THISROW].[Email]
),
TRUE
),1
)
)
For reference:
Thank you dear Aurelien, I will try right now
MUCHAS gracias Aurelien!!!!!
Ha funcionado muy bien!!! Gracias
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
Thank you dear Sara, but I think that essa is not good for text.
List of any numeric or any temporal type
User | Count |
---|---|
42 | |
25 | |
25 | |
17 | |
12 |