Multiple columns
Validations that compare values across two or more columns within the same row.
Column A must be greater than column B
Every value in column A must be greater than the value in column B for the same row. Optionally, equal values can be allowed.
Use this when you need to enforce a numeric relationship between two columns — for example, ensuring sale_price is always less than list_price, or that salary is always greater than bonus.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| Column A | Column | ✅ | The column whose values must be greater. |
| Column B | Column | ✅ | The column whose values must be smaller. |
| Values can be equal | Boolean | ❌ | If enabled, values in column A can be equal to column B. Default is false. |
Example
| employee_id | salary | bonus | commission |
|---|---|---|---|
| 1 | 3000 | 500 | 200 |
| 2 | 2500 | 2500 | 300 |
| 3 | 1800 | 2000 | 1700 |
| Example 1 | Example 2 | Example 3 | |
|---|---|---|---|
| Column A | salary | salary | salary |
| Column B | bonus | bonus | commission |
| Values can be equal | false | true | false |
| Result | ❌ Fails | ❌ Fails | ✅ Passes |
| Reason | Row 2 has equal values (2500 = 2500) and row 3 has bonus greater than salary | Equal values are now allowed — but row 3 still fails because bonus (2000) exceeds salary (1800) | All salary values are strictly greater than commission |