Names Default To Here(1);
dt = New Table("Untitled 3",
Add Rows(6),
New Column("S", Numeric, "Continuous", Format("Best", 12), Set Values([89, 89, 96, 96, 96, 96])),
New Column("O", Numeric, "Continuous", Format("Best", 12), Set Values([641, ., 834, ., ., .])),
New Column("R", Numeric, "Continuous", Format("Best", 12), Set Values([., ., ., 230, ., .]))
);
dt << New Column("Test", Numeric, Continuous, Formula(
If(Col Number(:O, :S) != 0 & Col Number(:R, :S), /*check if both :o</img> and :R have value for this :S*/
If(Col Cumulative Sum(!IsMissing(:O), :S) == 1, /* Check if row is first found value for :o</img> for this :S*/
:O
)
);
));
