cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
hmm
hmm
Level I

How Formula works in New Column Function

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?

Gay Porn - is the largest and most popular adult entertainment site for gay male pornography worldwide. Featuring a massive selection of movies, pictures, magazines, live shows and more, GayPorn.name has something to offer to every taste and kink. From intimate solo acts to hard-core gangbang scenes, there is no limit to what can be found here.

Every imaginable fantasy can be realized with GayPorn.name. With options such as amateur webcams, exclusive footage from professional porn makers, 3D virtual reality content and fetish videos for BDSM fans surfers are presented with an ever growing library of content they can enjoy without feeling overwhelmed by it all as the GayPorn catalogs are well organized and searchable for each convenient navigation.
1 REPLY 1
jthi
Super User

Re: How Formula works in New Column Function

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

-Jarmo