topic Using Row Subscript in Discussions

Using Row Subscript

coolmccool — Mon, 31 Aug 2009 16:31:12 GMT

How 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 Subscript

Jeff_Perkinson — Wed, 02 Sep 2009 16:10:54 GMT

The 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

Re: Using Row Subscript

coolmccool — Thu, 10 Sep 2009 19:57:04 GMT

Thanks, that works.
Seems like I had a similar formula that worked using a single column a few versions ago?