Add cells

[#1]

Hello, how could I do for: on a column add values when consecutive terms are equal and leave the initial values when the consecutive terms are different?

Ex:

[#2 · Accepted solution]

Not exactly sure how you would like your data to look, but using Dif (or Lag) in formula should work

Names Default To Here(1);

dt = New Table("Untitled",
	Add Rows(7),
	Compress File When Saved(1),
	New Column("Column 1",
		Numeric,
		"Continuous",
		Format("Best", 12),
		Set Values([1, 1, 2, 3, 4, 4, 4, 5])
	)
);

dt << New Column("Col", Numeric, Continuous, Formula(
	As Constant(val = :Column 1);
	If(Dif(:Column 1) == 0,
		val += :Column 1
	,
		val = :Column 1;
	);
	val;
));

[#3]

thank you for your reply @jthi !