And

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

  1. 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.

  2. 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.
Was this article helpful?
0 out of 0 found this helpful