Home : GFOA
Q14603 - INFO: GFOA

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).

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 10/6/2020 10:46 AM.
Last Modified on 2/8/2021 11:22 AM.
Last Modified by Scott Dorner.
Article has been viewed 825 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article