Multi Row formula

[rajputakansha]

Hi,

I have a data set in which I am trying to use a Multi-Row formula to get the below output.

It should assign each row a unique ID whenever the running total hits 0.

Values	Running Total	ID (OUTPUT)
-3000	-3000	1
-2000	-5000	1
3000	-2000	1
2000	0	1
100	100	2
-200	-100	2
100	0	2
10	10	3
20	30	3
30	60	3
-40	20	3
-20	0	3

Thanks for your help!

[DiganP · Accepted solution]

@rajputakansha The Multi-row formula would look something like this:

IF [Row-1:Running Total]=0 THEN [Row-1:New Field]+1 ELSE [Row-1:New Field] ENDIF

Does that work for you? 

[rajputakansha]

It absolutely works!!

Thank you !!