How do i sum up number of consecutive values within the same column?
Hi, I was able to identify consecutive values on a column "Data" (Refer to " sequence roll" column). However i need to generate a column (refer to Expected Result column) to sum up the number of consecutive values.Any help or advice will be appreciate. Thank you " sequence roll" columnIf( :Item == Lag( :Item, 1 ),
If( Dif( :Data, 1 ) == 1,
Dif( :Data, 1 ), .
), .
)