nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Create Formula

Hello everyone,

how can I calculate column X_9 and X_10 with a formula?

For X_9:
While X_1 = X_1 -> X_7(Row1) -X_8 = X_9

X_9 - X_8

For X_10:

While X_1 = X_1 -> X_10(Row1)=X_9 - X_8
X_9 + X_8

Thank you very much for your help!

V1_2_3 Anonymized.jmp

Accepted answers

txnelson

Here is my solution: The X__9 formula is

If( Row() == 1, sumX__8 = 0 );
If( :X__1 != Lag( :X__1 ),
	sumX__8 = 0
);
sumX__8 = sumX__8 + :X__8;
:X__7 - sumX__8;

The X__10 formula is

If( Row() == 1, theSum = 0 );
If( :X__1 != Lag( :X__1 ),
	theSum = 0
);
theSum = theSum + :X__8;
theSum;

Attached is a data table with the formulas applied

V1_2_3 Anonymized.jmp

All comments

Mark_Bailey

This kind of question has been asked many times. Did you search past discussions first for information that might help you solve this problem?

A formula is unlikely to use the While() function. You probably want to use the If() function. Also see the Lag() function.

Functions are documented. Please see Help > JMP Documentation LIbrary > Using JMP. There are chapters devoted to formulas and functions. Please see also Help > Scripting Index. Set this browser to display Functions (top left pull down menu) and then search for If and Lag.

txnelson

I am sorry, but I can not interpret your notation on what is required for X_0 and X_10. Can you explain it in written terms?

Hello,

thank for your answer.

I hope you can understand it now.

Best regards.

As long as the rows in column X_1 do not change
-> should be calculated in column X_9 = X_7 minus X_8.

As long as the rows in column X_1 do not change
-> column X_8 is to be added to column X_10

V1_2_3 Anonymized.jmp

txnelson

Here is my solution: The X__9 formula is

If( Row() == 1, sumX__8 = 0 );
If( :X__1 != Lag( :X__1 ),
	sumX__8 = 0
);
sumX__8 = sumX__8 + :X__8;
:X__7 - sumX__8;

The X__10 formula is

If( Row() == 1, theSum = 0 );
If( :X__1 != Lag( :X__1 ),
	theSum = 0
);
theSum = theSum + :X__8;
theSum;

Attached is a data table with the formulas applied

V1_2_3 Anonymized.jmp

Hello,
this is really wonderful!!

Thank you very much for that!

I hope that I soon begin to understand how to use the formula
... and can do it by myself.

I wish you a pleasant evening/afternoon(?).

Hello, txnelson,

do I understand your formulas correctly?

The formula for X_9
if the Row = 1 then sum X_8 = 0
If X_1 is not equal(?!=Lag) to X_1 then sumX_8=0
otherwise sumX_8=sumX_8 + X_8

and X_7 - sumX_8

The formula for X_10
if Row=1 then theSum=0
if X_1 does not equal(?!=Lag) X_1

theSum=0
otherwise theSum=TheSum + X_8
Fill out theSum

Is this correctly interpreted?

A sunny greeting and stay healthy!

This is wrong....

Hello I am trying to make the formula myself
How do I get the next If under it?

Thanks for your help.