BookmarkSubscribeSubscribe to RSS Feed
allan_deplanche

Community Trekker

Joined:

May 21, 2015

how to add 2 line ?

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
jvillaumie

Community Trekker

Joined:

Jun 9, 2014

Solution

Re: how to add 2 line ?

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
jvillaumie

Community Trekker

Joined:

Jun 9, 2014

Solution

Re: how to add 2 line ?

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

allan_deplanche

Community Trekker

Joined:

May 21, 2015

Re: how to add 2 line ?

Yes, Nice

Thank you