I would like to make an suggested_value: Hereby I would like to suggest the max number of the column +1
I tried MAX(List Personnes[Dossier ID])+1 but this results in the error:
โThe expression is valid but its result type โNumberโ is not one of the expected types: Listโ
Nevertheless I suggest a number and not a list?
What do you think? Bram
The suggested values (plural) formula must produce a list result, even if the list contains only a single value. The fix is simple: wrap you expression in the LIST() function to convert the single value to a list of one item:
=LIST(MAX(List Personnes[Dossier ID]) + 1)
Thx Steve! LIST() is doing his thing!
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |