Creating a Dynamic Group

[AL3XE167]

Hi, 

I am trying to group a sequence of numbers. Currently I only have Fields 1 and 2 in my data. Once Field 2 reaches 6 I want Field 3 to start a new grouping as demonstrated below. 

I'm sure its probably a multi-row formula but I cant think of how it needs to be configured. Any ideas welcome. 

Thanks in advance

Alex

Field1	Field2	Field3
1	1	1
2	2	1
3	3	1
4	4	1
5	5	1
6	6	1
7	1	2
8	2	2
9	3	2
10	4	2
11	5	2
12	6	2
13	1	3

[atcodedog05]

Hi @AL3XE167 

Here is how you can do it. Multi-row formula tool

IF [Row-1:Field2]=6 
THEN [Row-1:Field3]+1 
ELSEIF IsNull([Row-1:Field2])
THEN 1 
ELSE [Row-1:Field3] ENDIF

Workflow:

Hope this helps 🙂