MicroStrategy ONE

And

Returns TRUE if both the specified conditions are TRUE; otherwise, returns FALSE.

Syntax

Arg1 And Arg2

Where:

Arg1 and Arg2 are conditional expressions. The condition can contain metrics, comparison and logical operations, functions, and constants. The condition must be evaluated as TRUE or FALSE.

Example

A condition is defined as:

(Cost < 1000) And (Freight < 500)

This condition will return TRUE only if both, the Cost is less than 1000, and the Freight is less than 500.