Conditional Formatting

[#1]

I have data that contains different lots and reps and then time stamps.

I want all of the data from the same lot/rep to be divided by the final time stamp.

How would I do this in the formula section of a column?

[#2 · Accepted solution]

Col Max() with byvars (lot and maybe rep, depending on your data) should work.

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
dt << New Column("f", numeric, continuous, Formula(
	:height / Col Maximum(:height, :sex)
));

[#3]

Thank you, worked perfectly.