Multi Row Formula Issue

[rev]

Hello everyone,

Ran into an issue with alteryx. Still building up skills, hoping someone can help with the below. 

I want to add a column to the below dataset that effectively identifies a threshold using some logic. 

Acct	DELTA $
A	11,940,549
B	621,458
C	-6,847
B	-19,602
A	-2,601,305
B	-1,570,860
C	8,363,393
B	-16,322,719

The below is how I would like the threshold to be added. The simple logic being if Abs(Delta) > 50,000 grouped by Acct. 

But i want the count to increase on a specific account if there are more than one. Instead of just identifying, i would like to have a increasing number or alphabet, whatever makes it easier. 

THRESHOLD	Acct	DELTA $
1	A	11,940,549
1	B	621,458
	C	-6,847
	B	-19,602
2	A	-2,601,305
2	B	-1,570,860
1	C	8,363,393
3	B	-16,322,719

Any help is highly appreciated. have a good day!!

thanks!

[BenMoss · Accepted solution]

Hi, welcome to the community!

I've created a workflow that should bring you to a solution.

Firstly I isolated only the records that meet the criteria.

I then created an incrimental ID within each account group. Which can be achieved using the multi-row formula tool. I called the field 'ID' and use the syntax...

[Row-1:ID]+1

I then added 'acct' as a group by field, meaning it essentially restarts.

Finally I union back the data that did not meet the criteria.

I hope this helps.

Ben

[rev]

Thanks Ben, that was helpful.

Out of curiosity, I wanted to ask if there was a way to do the same with alphabets. 

Instead of incremental numbers, it would be A, B, C etc. 

Thanks,

Rev