HOW TO INCREMENT MAX VALUE ONE BY ONE

[BHUVANESH]

I HaveA Label Column :: [Label]=Wp223.

i am calculated the MAX value Of LABEL COLUMN::

CONDITION IS:

CONCATENATE(
"Test",
[Cohart Type Id],
MAX(
Select
(
work packages[Cohart type number],
[_THISROW].[Cohart type Id] = [Cohart type id]
)
)+ 1
)

BUT ITS NOT INCREMENT..IT SHOW ONLY HIGHEST VALUE OF LABEL COLUMN ...NOT INCREMENT

[Firdaus_AG]

My suggestion is try to add another column with any conditions required that store the number captured to create the next increment.

[Joseph_Seddik]

1. Where is that [Label] column in your expression?
2. By increment, do you mean converting "Wp223" to "Wp224"?