3383_en-US

liliconcom

If statement for most recent sampleHi,

I'm trying to create an IF statement for the following scenario:

26 weeks of data.
2 data columns (a & b).

For the most recent week, (if a > b, "More", "Less")

Simple enough, except that I'd like to label all rows with the result from the most recent week. For example, if b > a for all of the rows except the recent week, I'd like all of the rows to show "More", as the most recent week is a > b. Is there a way to do this in JMP?

Thanks!
JoshRe: If statement for most recent sampleThanks! That worked perfectly.

Really appreciate the help!
JoshRe: If statement for most recent sampleI can't verify this 100%, but you ought to be able to do something along the lines of:

n = NRow(); //or 26 if it's always 26
if(:a > ,"More","Less");

or, if not that, Row(n) should reference the last row.