Home : GCTV
Q10731 - INFO: GCTV
 GCTV returns the count of values that match a given text string.

SYNTAX:

GCTV(VarNum,GroupOffset/StartDate,Grouping/EndDate, Clause) 

VarNum:  The variable number that refers to the values you want to look at.

GroupOffset/StartDate: Used with the Grouping parameter to set the dates to calculate the stat for.  Sets the number of Groups (set by the Grouping Parameter) to be added to set the dates.  See examples below. If this field is a date string (i.e. "07/16/2004") or refers to a cell with a date in it, it is assumed to be the start date to calculate the stat for.

Grouping/EndDate: Used to set which dates to calculate the stat for.  If the Grouping is a date literal string (i.e. "07/16/2004") or refers to a cell with a date in it, it is assumed to be the end date to calculate the stat for. Common Groupings are:

"D" Days
“M” Monthly 
"R" Report Dates
Click here for available Grouping options

Clause:   The string to compare values to. Can Contain wild card characters. % = any string of characters. _ = Any single character.

NOTES:

Wildcard Characters represent a set of characters that the user can use to specify any different type of string. For example: If you wanted to know if the sun was out on any given day but you you didnt care how sunny. Suppose your database tracks 3 typs of sunny days Very Sunny days, Partly Sunny days, and Bearly Sunny days. If you wanted to count all 3 you could do it 2 ways. The first way is to use this function 3 times to count each type of sunny day and then add them all together. Or you could use wild card characters instead of whole strings. In this particular example you could use GCTV(VarNum, 1, "M", "%Sunny").

EXAMPLES:

Download Example Template: Help_GCTV_Examples.ss3 (Click here for download instructions)

See Also: GCP

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 2/11/2008 11:31 AM.
Last Modified on 2/15/2008 9:53 AM.
Last Modified by No Author Name Available!.
Article has been viewed 2577 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article