JSL for using a column group in a formula

[#1]

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

[#2 · Accepted solution]

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