Tips for Defining Column Calculations

Consider the following:

• DI recommends that you use Spectre calculations in a cPlan when working with a cPlan time series, and to use Diver calculations in a DivePlan or marker when working with a Diver time series. Do not mix the two.

• A calculation against a model that uses Info[] is converted to info() by Spectre if the marker is going against a cBase.

  If there are multiple possibilities for an info value due to data issues, the Info[ ] function picks a value to return.

  The Spectre info( ) function also returns a value if there is no info violation (that is, the expression is constant over all rows).

  An error returns a blank value. With Spectre, this applies to the Totals row for both numeric and string values (in models, strings are never presented in the Totals position).

• Avoid using model QuickViews in the calculation. Doing so can cause circular dependency issues.