Calendar year average (CYA#)

Calendar year average (CYA#)

As for CWA#, but for yearly processing. Calculates the average value for a series for each full calendar year between start and end dates. A calendar year runs from 1st January to 31st December.

Format

CYA#(Expression,Carry Indicator,Display Indicator)

Where Carry Indicator can be:

D Default; carry previous value, but not between periods

C Carry previous value

I Ignore

N N/A is displayed when there is a null value in the series

Display Indicator – the default is to display values only for complete periods, however the following optional parameters exist –

P Values calculated for incomplete calendar periods at the start of the display period

R Values calculated for incomplete calendar periods at the start and end of the display period

See Average format for details.

Example

CYA#(UKBCJD..,I)

This calculates the average unemployment in the UK for each full calendar year within the display period. Null values are ignored.

Limitations

The N parameter is not currently supported by the web Expression Builder in DFO / Datastream Charting, and the function is only accepted in the AFO Expression Builder if the Carry Indicator and optionally the Display Indicator are included within the expression. The function is however fully supported when used directly in AFO or DFO requests, and a line will be plotted successfully in Datastream Charting.

See also

Average functions