Template:Calculation Editing

To edit an existing calculation, use the dropZone or Workbench.

Your calculated series are marked with a blue formula flask. When you hover on the series and click on its flask

you get a menu with several calculation options. The first one opens the formula editor with the formula and setting for the calculation being edited.

Tab:

Formula

Inputs Section

The Series you checked are the inputs to your Formula:

Formula Section

Use V1, V2, etc. as your formula variables:

By their very nature, Calcuation Formulas are an open-ended topic. These are excellent points of departure:

• The dataZoa ComputeCloud Reference documents all of the intrinsic functions and arguments that can be used in Formulas. Downloasd it here.
• Nothing teaches quite like examples. See some here.

Buttons Section

Use these buttons to test and finally save your Formula:

Tab:

Options (Advanced)

These options are used to override the natural default behaviors for NA handling and the padding/trimming of series that do not start and end at the same point in time.

• NA Handling
• Missing_Values