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} );
Worked around, by hard coding the column names :
For Each Row(
r = Row();
Column = (:Name( "COL1" )) / (:Name( "COL23" ) + :Name( "COL24" ) + :Name( "COL25" )) ;
);
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
Worked around, by hard coding the column names :
For Each Row(
r = Row();
Column = (:Name( "COL1" )) / (:Name( "COL23" ) + :Name( "COL24" ) + :Name( "COL25" )) ;
);
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