community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Multi Row formula

Asteroid

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.

 

ValuesRunning TotalID (OUTPUT)
-3000-30001
-2000-50001
3000-20001
200001
1001002
-200-1002
10002
10103
20303
30603
-40203
-2003

 

Thanks for your help!

Alteryx
Alteryx

@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? 

 

Digan
Alteryx
Asteroid

It absolutely works!!

 

Thank you !!

Labels