How to get a formula column by row sub group

[#1]

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.

[#2]

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()?

[#3]

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.

[#4]

Thanks