Subscribe Bookmark RSS Feed

Using Row Subscript

coolmccool

Community Trekker

Joined:

Jun 23, 2011

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)
2 REPLIES
Jeff_Perkinson

Community Manager

Joined:

Jun 23, 2011

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
-Jeff
coolmccool

Community Trekker

Joined:

Jun 23, 2011

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