I would like to make an suggested_value: Here...

expressions
(Diogenes ASBL - VZW) #1

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

(Steven Coile) #2

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)

(Diogenes ASBL - VZW) #3

Thx Steve! LIST() is doing his thing!