Is Greater Than [GT]

Return to Complete List of Functions

The Is Greater Than function determines if one value is greater than another value. Parameters ------------------ Value 1       The first value to use in the condition. This is the greater of the two values when true. Value 2       The second value to use in the condition. This is the lesser of the two values when true. Both values can be any combination of raw data, calculated values, or constants. Function Value ------------------------ This function returns 1 if value 1 is greater than value 2; otherwise, it returns 0. If either value is null, a null is returned. This type of comparison is useful for rules in entry/exit systems or as a condition in an if function. Value 1   Value 2     GT(Value 1,Value 2) -----------------------------------------------------------------     0             0                        0     0             1                        0     1             2                        0     1             1                        0     2             0                        1