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
- :
- 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

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

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

Sep 2, 2009 9:10 AM
(381 views)

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

Sep 10, 2009 12:57 PM
(381 views)

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