Need to Identify by number the Component Material for each Bundle Material

[latimo1]

Bundle Material	Count	Right_Bundle Material	Component Material	Order
PURY-P336YSLMU-A-KIT	2	PURY-P336YSLMU-A-KIT	CMY-ER200CBK	1
PURY-P336YSLMU-A-KIT	2	PURY-P336YSLMU-A-KIT	PURY-P168YLMU-A	2

I can't figure out how to generate the Order Number.

TIA! John!

[alexnajm]

RecordID tool will do the trick! You can even group on the Bundle Material if you need the count to restart back to 1 after each unique material.

 Record ID Tool

[jrlindem]

Yep, @alexnajm 's response is perfect for numbering off records.

But if you have multiple (duplicate) Bundle Material ID's, you can also use the Multi-Row Formula tool to count them with repeated numbers and only +1 (go up by 1) when a new Bundle Material ID occurs in the list.

[alexnajm]

@jrlindem I think I addressed that with the grouping functionality mentioned 😊

[jrlindem]

@alexnajm you're right!  *facepalm.  Sometimes I get so excited to answer my eyes don't see parts of other's responses.  Thanks for keeping me honest.  -Jay

[alexnajm]

All good @jrlindem ! I did edit it 2 seconds after I posted it after I noticed the subject line so maybe that didn't reflect just yet

[alexnajm]

@latimo1 / John can you let us know if the solutions worked?