This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Created:
Feb 10, 2019 10:41 AM
| Last Modified: Feb 10, 2019 7:41 AM(8027 views)
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()?
Created:
Feb 11, 2019 04:23 AM
| Last Modified: Feb 11, 2019 1:23 AM(743 views)
| Posted in reply to message from Thomas1 02-11-2019
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.