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 ?
Go to 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