How to reset ChangeCounter to 0 instead of 1?

[Paulo]

Hello all! I hope someone could help me with this issue. I'm using a ChangeCounter column (named [counter]) that I want to accumulate on edit until the value is 5. After that, I want the column to reset to 0. In the 'Reset on edit?' I'm using the formula "[counter] = 4" and in 'Initial value' I'm using 0.
The problem is: when I reach 5 in the counter column, the value resets to 1 instead of 0. What am I missing here?

[dbaum · Accepted solution]

Maybe it indeed resets to 0 and then increments to 1 triggered by same row edit/save that triggers the reset on edit. You could try using an initial value of -1 (maybe only if it's not a new row) or excluding certain columns from the Change column's trigger.

[Paulo]

Thank you @dbaum! After changing the initial value to -1 it works like a charm!