GTE (>=)
Category: Logical functions
Overview
Description | If the matching row on the first input is greater than or equal to the matching row in the second input, true (1) is returned, false (0) otherwise. Undefined values are treated as false (0). Use when you need a 1/0 flag to mark where one input is greater than or equal to another. |
|---|---|
Syntax |
|
Parameters |
|
Examples
Checking whether one input is greater than or equal to another
This example compares two input nodes row by row. The result returns 1 where the first input is greater than or equal to the second and 0 otherwise.
Input node: A
Year | Value |
|---|---|
2025 | 400 |
2026 | 700 |
2027 | 850 |
2028 | 500 |
Input node: B
Year | Value |
|---|---|
2025 | 350 |
2026 | 400 |
2027 | 850 |
2028 | 600 |
Formula: GTE('A', 'B')
Year | → GTE Result |
|---|---|
2025 | 1 |
2026 | 1 |
2027 | 1 |
2028 | 0 |