topic Re: How do I get a JSL script to Sum cells based of other cells. in Discussions

How do I get a JSL script to Sum cells based of other cells.

SampleFerret107 — Wed, 18 Dec 2024 16:59:37 GMT

Hi All,

I've gotten stuck trying to write a script that will Sum cells based on 2 other cells within the same row.

Im able to select the correct rows with

dt << row selection (Select where (:Column 3== CurrentWrkWk & :Column 1== "TIM703"));

Final answer I expect is

The sum should be 3.913.

Ive been reading the scripting index but am lost

Names Default To Here( 1 );
Clear Globals();
dt = current data table();
CurrentWrkWk = 202450;


a1 == dt << row selection (Select where (:Column 3== CurrentWrkWk & :Column 1== "TIM703"));
Var1 =Col Cumulative Sum(:StateHour, a1);

show(Var1);

JMP version 17

Re: How do I get a JSL script to Sum cells based of other cells.

txnelson — Wed, 18 Dec 2024 17:15:00 GMT

I think this might do what you want

Var1 = Col Cumulative Sum(
	If( :Column 3 == CurrentWrkWk & :Column 1 == "TIM703",
		:StateHour,
		.
	),
	a1
);

Re: How do I get a JSL script to Sum cells based of other cells.

jthi — Wed, 18 Dec 2024 17:27:22 GMT

For sum you can also use data table subscripting

Names Default To Here( 1 );

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

age_of_interest = 12;
sex_of_interest = "F";

rows_of_interest = dt << Get Rows Where(:age == age_of_interest & :sex == sex_of_interest);

res = Sum(dt[rows_of_interest, "height"]);

Re: How do I get a JSL script to Sum cells based of other cells.

SampleFerret107 — Wed, 18 Dec 2024 18:05:28 GMT

Hi Jthi,

Thank you this has worked