cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
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)));