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 ?

- 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
- Permalink
- Email to a Friend
- Report Inappropriate Content

May 21, 2015 1:39 AM
(2462 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

Solved! Go to Solution.

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

May 21, 2015 8:18 AM
(4480 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

2 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

May 21, 2015 8:18 AM
(4481 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
- Permalink
- Email to a Friend
- Report Inappropriate Content

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

Yes, Nice

Thank you