How Formula works in New Column Function

hmm — Tue, 12 Sep 2023 11:25:42 GMT

dt = Open( "$SAMPLE_DATA\Big Class.jmp" );
New Column("Sum",
"Numeric",
"Continuous",
Set Formula(If(Row() == 1, :Height, Lag(:Sum,1) + :Height))
);

The code above creates Sum column with calculated the accumulative sum. I am new to JSL so could someone explain me how the Formula command works. Is it scan one by one row in the column so that we can write :Height instead of constructing a For-loop with [i] which indicates the position of the current rows.

And have any other ways to do this cumsum?

Re: How Formula works in New Column Function

jthi — Tue, 12 Sep 2023 11:33:37 GMT

Regarding formulas in JMP Using JMP > Create Formulas in JMP . Other option to create Cumulative Sum could be to use Col Cumulative Sum()

topic Re: How Formula works in New Column Function in Discussions

How Formula works in New Column Function

Re: How Formula works in New Column Function