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?