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
- :
- 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
(3305 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
(5323 views)
| Posted in reply to message from allan_deplanche 05/21/2015 04:39 AM

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
(5324 views)
| Posted in reply to message from allan_deplanche 05/21/2015 04:39 AM

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

Re: how to add 2 line ?

Yes, Nice

Thank you