JMP 17.2.0
I came across this thread, which was a perfect solution to calculating a time difference between rows, using the formula below in a Formula Column.
Col Cumulative Sum(Dif(:Time))
However, I am getting a blank/missing item in the first cell of the Formula Column, which then causes my resulting graph to not start at zero.
![polymerist_1-1722622321987.png polymerist_1-1722622321987.png](/t5/image/serverpage/image-id/66773iE436A7EEB50CC323/image-size/medium?v=v2&px=400)
Right now, I'm getting around it by inserting a row at the top of the data table with the same time, which results in Row 2 providing a zero-point.
![polymerist_2-1722622422505.png polymerist_2-1722622422505.png](/t5/image/serverpage/image-id/66774iD3B108FC8AA3FDF6/image-size/medium?v=v2&px=400)
Is there a way to treat the missing value as zero in a locked column? Or better yet, is there an edit I can make to the formula to form a T0 point?
Thanks in advance!