- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Sum of all rows into a list
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?
2 ACCEPTED SOLUTIONS
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Sum of all rows into a list
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 ) )
);
Jim
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Sum of all rows into a list
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];
-Jarmo
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Sum of all rows into a list
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 ) )
);
Jim
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Sum of all rows into a list
Thank you. Both of your solutions work great.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Sum of all rows into a list
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];
-Jarmo