topic Re: subtract cells from different rows in Discussions

subtract cells from different rows

AFaiz — Thu, 18 Apr 2024 19:56:43 GMT

is there a way to do this calculation in JMP?

i would like to subtract cell 1 from cell 2 and place the result in a new column, cell3 from cell4, and so on.

Re: subtract cells from different rows

jthi — Thu, 18 Apr 2024 20:06:37 GMT

You can use Lag() to access values from other rows of a column. Then you can create a formula using Lag between those two columns you have

Names Default To Here(1); 

dt = open("$SAMPLE_DATA/Big Class.jmp");

dt << New Column("S", Numeric, Continuous, Formula(
	Lag(:weight) - :height 
));

Re: subtract cells from different rows

AFaiz — Thu, 25 Apr 2024 19:42:42 GMT

it works great. Thank you so much