GFOA spread function returns the minimum frequency of analysis for the grouping in the report date range along with the grouping (ie 03/07, 06/30, etc...)
SYNTAX:
GFOA(VarNum, Grouping, Optional Display)
VarNum: The variable number to get the count for.
Grouping: Used to set which dates to calculate the stat for. GFOA ONLY works with the following groupings: "D" - Days "Wx" - All weekly groups "M" - Monthly "Q" - Quarterly "Y" - Yearly
Display: Optional. If set to 1 will display "01/01" if all days of the group have a result. Otherwise it will show the count for the group (ie 07/07,31/30 etc...). Default is off.
NOTES:
Typically used when reporting the Frequency of Analysis code for DMRs.
EXAMPLES:
GFOA(4101,"W7") returns the number of minimum number of results for the week (W7 Sun-Sat) for variable 4101 for the report date range.
GFOA(11,"W7",1) returns the number of minimum number of results for the week (W7 Sun-Sat) for variable 11 for the report date range. Since Display is set to 1 if all weeks have 7 samples will return 01/01, otherwise it will show the minimum result count for weeks in the report date range (ie. 04/07).
|