topic Re: Sum of all rows into a list in Discussions

Sum of all rows into a list

wyler00 — Tue, 09 Apr 2024 22:18:28 GMT

I'm trying to take the sum of all of my rows and add it to a list. So, the sum of row 1 will be item 1, sum of row 2 will be item 2, etc. Is there an easy way to do this using jsl?

Re: Sum of all rows into a list

txnelson — Wed, 10 Apr 2024 01:37:37 GMT

Here is one way to do it. Others may have better methods

Names Default To Here( 1 );
dt = Current Data Table();
sumMatrix = [];
For Each( {col}, dt << get column names( string, numeric ),
	sumMatrix = sumMatrix || Col Sum( Column( dt, col ) )
);

Re: Sum of all rows into a list

jthi — Wed, 10 Apr 2024 04:24:21 GMT

You can also use matrix calculations, below is one option

Names Default To Here(1); 

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

m = dt << get as matrix;

sums = V Sum(m`);

tolist = As List(sums)[1];

Re: Sum of all rows into a list

wyler00 — Wed, 10 Apr 2024 15:51:50 GMT

Thank you. Both of your solutions work great.