Check highest number in column and add +1 for new entry

[mymymy]

I'd like to have a column, which increases decimal numbers by 1. Therefore it probably needs to check each time a new point is added for the maximum value at the moment and add +1 to this new point.
It is not used as Key.
I've tried with the initial value set to MAX(LIST([_THIS]))+1 but it does not work correctly. Do you know why or if I have to do it in an other way?

[Swoopy · Accepted solution]

Have you tried?

MAX(tableName[columnName]) + 1

[mymymy]

perfect, that works! thanks a lot!

[Swoopy]

You're welcome.

[Marc_Dillon]

https://community.appsheet.com/t/serial-numbers-if-you-must/19325

[mymymy]

good input! Thanks!