topic Re: Conditional Formatting in Discussions

Conditional Formatting

JMPUser9 — Wed, 14 Jun 2023 19:10:22 GMT

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?

Re: Conditional Formatting

jthi — Wed, 14 Jun 2023 19:20:33 GMT

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)
));

Re: Conditional Formatting

JMPUser9 — Wed, 14 Jun 2023 22:52:59 GMT

Thank you, worked perfectly.