674_en-US

liliconcom

Using Row SubscriptHow can I use the row subscript function to get the maximum value from another column for all rows preceding the current row?
Here is what I would like to do:
(current row value)/(Max row value from only the rows above current row)Re: Using Row SubscriptThanks, that works.
Seems like I had a similar formula that worked using a single column a few versions ago?Re: Using Row SubscriptThe most straightforward way to do this is with two columns, each with it's own formula:

Use the Big Class.jmp sample data table and create two columns with the following formulas to see what I mean.

Max height so far = If(Row() == 1, :height, Maximum(:height, :Max Height so far[Row() - 1]))

Proportion of max height so far = :height / :Max Height so far

I'm still working to see if I can do it in a single column.

Jeff