Time Series Calculations

Calculated fields can either be Static numeric Columns or numeric Time Series.

If one of the expressions used is a Time Series Measure, then the result will be a new numeric Time Series calculated column.

Example calculations may be:

Forecast Variance = ( [Actual] - [Forecast] ) / [Forecast]

Holding = [NumberofShares] * [LastPrice]

As with standard calculated columns, Time Series calculated columns are calculated for every time slice and every item within the data set.