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

[Diogenes_ASBL_V]

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]

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_V]

Thx Steve! LIST() is doing his thing!