Creating an ID that will increment by 1 when a certain value is found

[Deano478]

Hi All,

I asked a question earlier today and the solution worked like a charm, however I have one final hurdle to jump over to complete this project i'm working on. I have a sample of my input dataset like below (anonymised for this question). 

Input:

No	Type	Date	Name	Account	Ref	Details	Dept	T/C	Value
N/C:	12		Name:		Account 1
31111	TL	31/07/2019		12	DEPREC	Test Transaction 1	1	T9	69.17
32222	YL	31/07/2019		12	DEPREC	Test Transaction 2	1	T9	55
33333	TL	31/07/2019		12	DEPREC	Test Transaction 3	0	T9	303.33
34444	YL	31/07/2019		12	DEPREC	Test Transaction 4	0	T9	36.67
35555	YL	31/07/2019		12	DEPREC	Test Transaction 5	0	T9	11.67
36666	TL	31/07/2019		12	DEPREC	Test Transaction 6	0	T9	25.58
	YL	31/07/2019		12	DEPREC	Test Transaction 7	0	T9	12.17
N/C:	41		Name:		Account 2
37777	TL	31/07/2019		13	DEPREC	Test Transaction 1	0	T9	9.85
38888	YL	31/07/2019		13	DEPREC	Test Transaction 2	1	T9	6.3

What I'm trying to achieve I know requires the use of a multi row formula however any expressions I have tried have unfortunately been to no avail What I'm trying to achieve is anytime N/C: appears an ID will increment so I'm hoping to achieve the below

Output:

No	Type	Date	Name	Account	Ref	Details	Dept	T/C	Value	Increment_ID
N/C:	12		Name:		Account 1					1
31111	TL	31/07/2019		12	DEPREC	Test Transaction 1	1	T9	69.17	1
32222	YL	31/07/2019		12	DEPREC	Test Transaction 2	1	T9	55	1
33333	TL	31/07/2019		12	DEPREC	Test Transaction 3	0	T9	303.33	1
34444	YL	31/07/2019		12	DEPREC	Test Transaction 4	0	T9	36.67	1
35555	YL	31/07/2019		12	DEPREC	Test Transaction 5	0	T9	11.67	1
36666	TL	31/07/2019		12	DEPREC	Test Transaction 6	0	T9	25.58	1
	YL	31/07/2019		12	DEPREC	Test Transaction 7	0	T9	12.17	1
N/C:	41		Name:		Account 2					2
37777	TL	31/07/2019		13	DEPREC	Test Transaction 1	0	T9	9.85	2
38888	YL	31/07/2019		13	DEPREC	Test Transaction 2	1	T9	6.3	2

Cheers for any assistance with this it's been a real head scratcher for me.

[DavidSkaife · Accepted solution]

Hi @Deano478 

Try this: Create a column called Increment_ID and assign it a numerical value of 1, then use a Multi-Row tool with the following formula

IF [No] = 'N/C:' 
THEN [Row-1:Increment_ID]+1
ELSE [Row-1:Increment_ID]
ENDIF

[Deano478]

@DavidSkaife Massive thanks I've been scratching my head over this for a while it wasn't overly complex in the end it just took some less complex thinking on my part many thanks again