cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
PNash
Level II

JSL for using a column group in a formula

Hi;

 

New to JMP / JSL.  I'm trying to add a formula column at the end of a set of data that calculates the STD DEV of the column data.  The header data will be variable, so I need a generic assignment of column numbers.

 

My script is obviously wrong, otherwise I wouldn't be here but this is what I was trying;

 

 

dt << Group Columns ("Weeks", Column (2), 26);
dt << New Column ("STDEV", Characteristic, Formula (std dev("Weeks")));

 

 

Any guidance is appreciated!  Thanks!

-Phil

1 ACCEPTED SOLUTION

Accepted Solutions
PNash
Level II

Re: JSL for using a column group in a formula

Nevemind, figured it out!

dt << Group Columns ("Weeks", Column (2), 26);
colgrp = dt << get column group("Weeks");
dt << New Column ("STDEV", Numeric, Formula (std dev(colgrp)));

View solution in original post

1 REPLY 1
PNash
Level II

Re: JSL for using a column group in a formula

Nevemind, figured it out!

dt << Group Columns ("Weeks", Column (2), 26);
colgrp = dt << get column group("Weeks");
dt << New Column ("STDEV", Numeric, Formula (std dev(colgrp)));