Description
The AND function evaluates multiple conditions and returns TRUE if all conditions are met. If any condition is not met, it returns FALSE.
Usage
The function is used to check if multiple conditions are true.
Syntax:AND(condition1, condition2, [condition3], …)
Examples
-
Check Latest Value in a Table:
AND(LATEST(#[Actions].[Number] > 1), true)This evaluates whether:
- The latest value in the Number column of the Actions table is greater than 1.
- A second condition, true, is also satisfied.
The function returns TRUE only if both conditions are met.
-
Evaluate a Calculation:
AND(#[Calculation], true)This checks:
- Whether the result of a calculation is true.
- A second condition, true, is also satisfied.
The function returns TRUE only if both conditions are met.
Inputs
| Argument | Data Type | Description |
|---|---|---|
| condition1 | Boolean | The first condition to evaluate. |
| condition2 | Boolean | The second condition to evaluate. |
| [condition3] | Boolean | (Optional) Additional conditions. |
Returns
Type: Boolean
- Returns TRUE if all conditions are met.
- Returns FALSE if any condition is not met.