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
Thomas1
Level V

How to get a formula column by row sub group

Hi there,

 

I d like to create a formula column (sum or mean etc.) with sub groups. The sub groups should be selected by rows, for example all 5 following rows drom a data table or in general all N rows. Any ideas to solve this with row()?

Attache a file to add the formula column.

 

12 REPLIES 12
Thomas1
Level V

Re: How to get a formula column by row sub group

Hi ms,

 

Thanks for the update. The local approach delivers the results, without error code from the formula editor.

By the way, what is the difference between Parameter() and local()?

ms
Super User (Alumni) ms
Super User (Alumni)

Re: How to get a formula column by row sub group

As I understand it, Local() simply let variables to be defined and evaluated within the context of the column formula, eliminating risk of interference with global variables with the same name. Parameters are used in optimization problems, i.e. the nonlinear platform.

 

 

Thomas1
Level V

Re: How to get a formula column by row sub group

Thanks