cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
coolmccool
Level I

Using Row Subscript

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 2
Jeff_Perkinson
Community Manager Community Manager

Re: Using Row Subscript

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
Level I

Re: Using Row Subscript

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