topic Re: Sum specific columns in each row in Discussions

Sum specific columns in each row

DataMojo — Sun, 12 Feb 2017 21:08:50 GMT

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} );

DataMojo — Sun, 12 Feb 2017 21:45:04 GMT

Worked around, by hard coding the column names :

For Each Row(
r = Row();

Column = (:Name( "COL1" )) / (:Name( "COL23" ) + :Name( "COL24" ) + :Name( "COL25" )) ;

);

Craige_Hales — Sun, 12 Feb 2017 23:14:19 GMT

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