MVGT counts the number of values from the specified set of variables that are greater than the Compare Value.

SYNTAX:

MVGT(CompareValue, Cj, Cn:Cw, Cy, ...)
where :
CompareValue specifies the value to compare each variable to; this can be a constant defined in the function or a conditional variable.
Cx is a conditional variable x

NOTES:

Each variable must be specified as a Conditional Variable (use "C" instead of "V").

The variables may be referenced two different ways;  single variables separated by commas or a range specified by a beginning variable, a colon, and an ending variable.  These two methods can be combined. (i.e., C14:C22 will include all variables whose numbers fall between Variable 14 and Variable 22)

When specifying a range of variables,  there can be gaps in the series of existing variables.  For instance, if the specified range is C11:C17 and variable 14 does not exist, the function will calculate the remaining variables.

This function only works properly when ALL variables (Target and Source) are the same frequency, i.e. all daily, all hourly, etc...  

This function will handle up to 199 variables.

EXAMPLES:

Example 1: CompareValue = A constant

V214 = MVGT(2.5, C70,C71,C1001:C1004,C1011)

Variable 214 will contain the count of variables 70,71,1001,1002,1004 and 1011 that are above 2.5 each day:

Example 2: CompareValue = A conditional variable

V124 = MVGT(C70,C71,C1001:C1004,C1011)

In this example, variable 70 is the Compare Value.  Each day, variable 124 will be a count of the number of the other variables that are higher than variable 70 on that day:

Example 3: Using Daily Detail (4 Hour) variables

V11379 = MVGT(2,C11377,C11378)

where V11379,V11377, and V11378 are all 4-hour daily detail variables.  Note, to calculate values must be in the same data slot, not necessarily the same time.