BookmarkSubscribe
Choose Language Hide Translation Bar
allan_deplanche
Community Trekker

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

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
jvillaumie
Community Trekker

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 2
jvillaumie
Community Trekker

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

Re: how to add 2 line ?

Yes, Nice

Thank you

0 Kudos