- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Sum specific columns in each row
I would like to sum specific columns in each row.
I can find the maximum value in each row using the below :
location = Loc Max( dt[r, {a,b,c} );
but cannot use the sum
Total = Sum( dt[r, {a,b,c} );
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Sum specific columns in each row
Worked around, by hard coding the column names :
For Each Row(
r = Row();
Column = (:Name( "COL1" )) / (:Name( "COL23" ) + :Name( "COL24" ) + :Name( "COL25" )) ;
);
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Sum specific columns in each row
Maybe a missing ] ? This works for me.
dt=open("$sample_data/big class.jmp");
sum(dt[3,{height,weight,age}]);
Maybe the r variable is uninitialized. Use show(r); to see what it is. Check the JMP log window for messages.
Not sure why you would add these together
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Sum specific columns in each row
Worked around, by hard coding the column names :
For Each Row(
r = Row();
Column = (:Name( "COL1" )) / (:Name( "COL23" ) + :Name( "COL24" ) + :Name( "COL25" )) ;
);
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Sum specific columns in each row
Maybe a missing ] ? This works for me.
dt=open("$sample_data/big class.jmp");
sum(dt[3,{height,weight,age}]);
Maybe the r variable is uninitialized. Use show(r); to see what it is. Check the JMP log window for messages.
Not sure why you would add these together