Item numbering rule to create an autosequence that starts with 0
Hello everyone,
as described in the summary, we are defining Item Rules and want to create an auto_sequence that starts with “001” and increments by 1.
If we try to write auto_sequence(“x”;001;1) the first number that is generated is “1”.
We tried with:
-lpad(auto_sequence(“x”;1;1),3, “0”)
-text(auto_sequence(“x”;1;1), “000”)
In both cases the system reveals a syntax error.
We would also like to avoid the work around of defining three conditions that consider the length of the sequence.
For example:
- if length(auto_sequence(“x”;1;1) ==1) then “00” + auto_sequence(“x”;1;1)
- if length(auto_sequence(“x”;1;1) ==2) then “0” + auto_sequence(“x”;1;1)
Tagged:
0