Calendar year sum (CYS#)

Calendar year sum (CYS#)

This calculates the sum of values for a series for each full calendar year within the display period. A calendar year runs from 1 January to 31 December.

Format

CYS#(Expression,Carry Indicator,Display Indicator)

Where the optional 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.

Example

CYS#(SAGLDOUTH,P)

This calculates the output (in kilograms) of South African gold production for each full calendar year within the display period.

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 both/neither the Carry Indicator and/nor 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

Sum functions