Reference Updated April 8, 2026

LTE (<=)

Overview

Description	If the matching row on the first input is less 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 less than or equal to another.
Syntax	`LTE('Node1', 'Node2')` `'Node1' <= 'Node2'`
Parameters	Node1: First input node, specified using the node name in single quotes (e.g. `'Profit'`). Node2: Second input node.

Description

If the matching row on the first input is less 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 less than or equal to another.

Syntax

`LTE('Node1', 'Node2')`
'Node1' <= 'Node2'

Parameters

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

Examples

Checking whether one input is less than or equal to another

This example compares two input nodes row by row. The result returns 1 where the first input is less 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: LTE('A', 'B')

Year	→ LTE Result
2025	0
2026	0
2027	1
2028	1

Function	When to use instead
LT (<)	When equality should not count as a match and the first input must be strictly less.
GTE (>=)	When you need to check the opposite direction and include equality for values that are greater than or equal.

Overview

Examples

Checking whether one input is less than or equal to another

Related Functions