210305_en-US

liliconcom

Create repeat sequence by group

Hi,

I have data as below, I would like to create sequence as "Expected result".

I also attach file.

Thanks in advance.

 

Re: Create repeat sequence by group

Thank you so much txnelson for formula.

 

Re: Create repeat sequence by group

Here is a formula that will do that

If( Row() == 1, seq = 0 );
If( Lag( :Group ) != :Group,
 seq = 0
);
If( :Run == 1, seq = seq + 1 );
seq;