GT (>)

In Logical functions

The GT function checks whether the matching row on the first input is greater than the matching row in the second input; true (1) is returned, false (0) otherwise. Undefined values are treated as false (0).

Use this function when you need a 1/0 flag to mark where one input is greater than another.

Parameters

Node1Node referenceRequired

First input node, specified using the node name in single quotes (e.g. 'Profit').

Node2Node referenceRequired

Second input node.

Example

Checking whether one input is greater than another

This example compares two input nodes row by row. The result returns 1 where the first input is greater than the second and 0 otherwise.

Input node: 'A'

Input node: 'B'

Formula: GT('A', 'B')

See also

GTE (>=)

When equality should also count as a match instead of requiring the first input to be strictly greater.

LT (<)

When you need to check whether one input is less than another instead of checking for equality.

EQ (=)

When you want to check for exact matches instead of a greater-than condition.