Home : GCC
Q10469 - INFO: GCC

GCC returns an aggregate conditional count statistics for an input variable.
The number of values that are aggregated is determined based on the frequency of the input variable.

SYNTAX:

GCC(Cx, "comp", Exp)
where :
Cx is a input conditional variable x.
comp is a comparison operator. Any valid operator such as >,<,=,<>,<=,>=. Must be in quotations.
Exp is an algebraic or boolean expression. It is used as a value for comparison.

NOTES:

The input variable frequency should be less than the result variable frequency. It makes sense to aggregate 5 one-minutely values into a 1 five-minute variable, but not the other way around.

EXAMPLES:

V6071 = GCC(C6000,"<",2)

where V6000 is a 15 minute variable, and V6071 is an hourly variable.

TECH NOTES:

GCC function cannot be preceded by algebraic functions (+, -, *, / etc).  Example: 5 + GCC(C1,"<",1) returns error "<--- Algebraic type not allowed in + operation."  However, GCC(C1,"<",1) +5 does work.

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/1/2007 2:21 PM.
Last Modified on 6/16/2026 11:37 AM.
Last Modified by Scott Dorner.
Article has been viewed 4428 times.
Rated 8 out of 10 based on 4 votes.
Print Article
Email Article