Counting a Project name

Gpatwa

I am counting the project item(List: Project name) based and generating a unique number by adding +1 to count . everything is working fine until a situation comes where i have to delete some existing projects.

1. When i delete the project → my count reduces and the way i am creating a unique number which is by +1 to my count (is giving me wrong answers)
   1. What should i do so that my count doesnt get affected even if i delete my project item.

KirillKuznetsov

@Gpatwa

There are multiple ways to resolve this.

1) You can try to store the last code generated in a separate line item (no dimensions)

2) use the cumulate formula for your counter CUMULATE(1, FALSE, Project name)

3) Take the maximum code number (using the Summary method: Max) and add 1 to it each time you want to create a new item.