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