This calculates the sum of values for a series for each full calendar month within the display period. A calendar month runs from the first working day of the month to the last working day of the month.
CMS#(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 period.
CMS#(BGAS(NT))
This calculates the total number of trades (the number of times shares were traded) for British Gas for each full calendar month within the display period.
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 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.