Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- Using Row Subscript

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Using Row Subscript

Aug 31, 2009 9:31 AM
(1543 views)

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)

Here is what I would like to do:

(current row value)/(Max row value from only the rows above current row)

2 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Using Row Subscript

Sep 10, 2009 12:57 PM
(1455 views)
| Posted in reply to message from Jeff_Perkinson 09/02/2009 12:10 PM

Thanks, that works.

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

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