This calculates an average value for a series between two dates – all values are included in the calculation even if they are null. For example, if you request a 20 day average for a period that includes one null value – 20 is used as the denominator and the 19 values are summed for the numerator.
AVGA#(Expression,Start date,End date)
This calculates a single average value between the start date and end date. Actual dates are typed using either the standard format DD/MM/YY, or the displacement date format, for example, -NY.
As a date parameter one can also use YRE, HFE, QTE, MTE, WKE, LYE, BDATE, BDATEXXF
AVGA#(Expression)
If you do not specify start and end dates, the defaults are the start and end dates for the display period.
AVGA#(FOODSUS(PE),1/1/98,31/12/98)
This static format calculates the average price earnings (PE) for the US food sector for 1998.
AVGA#(FOODSUS(PE))
This default static format calculates the average PE for the US food sector between the start and end dates for the display period.