topic Calculate difference between 2 group in Discussions

Calculate difference between 2 group

kluu — Thu, 08 Jun 2023 14:44:26 GMT

Hi Everyone,

I am new with jmp. I have a data table like the below:

index Team value

1 a 5

2 a 12

3 a 20

4 b 5

5 b 22

6 b 6

I want to create a new column, "delta", that calculate the differences between the index group by "team", so i would have something like this:

index Team value delta

1 a 5 .

2 a 12 .

3 a 20 .

4 b 5 0

5 b 22 -10

6 b 6 14

Could you help with the jsl column formula?

Thanks

Khanh

Re: Calculate difference between 2 group

txnelson — Thu, 09 Mar 2023 02:56:21 GMT

Here is a formula that works for your example table.

If( Row() == 1,
	startTeam = :Team;
	theList = {};
	theDelta = .;
);
If( :Team == startTeam,
	Insert Into( theList, :value ),
	If( :Team != Lag( :Team ),
		count = 0
	);
	count++;
	theDelta = theList[count] - :value;
);
theDelta;

Re: Calculate difference between 2 group

kluu — Fri, 10 Mar 2023 01:54:41 GMT

Thank you Jim. It works