How to return the Max number of a column

Platform discussions
, ,
1

Hello, I am trying to generate the next drawing number by finding the max number in the column and adding 10 when a new item is generated. But it seems I can’t get the max number of the column.
Can you tell me what I do wrong in my formula?
if({Drawing Number}<>“”,right({Drawing Number},7),Concatenate(“Q”, sum(max({Drawing Number}),10)))

2

Hi Xavier,

Your question is not clear. You should post a screenshot.