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
- :
- how to add 2 line ?

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

May 21, 2015 1:39 AM
(1469 views)

hello,

I need to add cumulted process time between 2 lines

So i add a new column and i would like to add a formula

for example : add "line -1 + line"

Wich formula could do this ?

Thx

1 ACCEPTED SOLUTION

Accepted Solutions

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

May 21, 2015 8:18 AM
(2696 views)

Solution

If I understand what you are trying to do correctly, then what you are looking for is "subscript" and "row()" from the first group of functions, "Row".

To tell JMP to add the value in a column called TheTime @ "row -1", to the value of TheTime @ "row" , add "row() - 1" as a subscipt to TheTime in the formula.

You can create a column called TheTime and paste the following expression in some other column's formula :

:TheTime[Row() - 1,Empty()] + :TheTime

2 REPLIES

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

May 21, 2015 8:18 AM
(2697 views)

If I understand what you are trying to do correctly, then what you are looking for is "subscript" and "row()" from the first group of functions, "Row".

To tell JMP to add the value in a column called TheTime @ "row -1", to the value of TheTime @ "row" , add "row() - 1" as a subscipt to TheTime in the formula.

You can create a column called TheTime and paste the following expression in some other column's formula :

:TheTime[Row() - 1,Empty()] + :TheTime

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

May 21, 2015 11:33 PM
(1348 views)