Export (0) Print
Expand All

AND (DMX)

Performs a logical conjunction on two numeric expressions.

Expression1 AND Expression2

Expression1

A valid Data Mining Extensions (DMX) expression that returns a numeric value.

Expression2

A valid DMX expression that returns a numeric value.

A Boolean value that returns TRUE if both parameters evaluate to TRUE; otherwise FALSE.

Both parameters are treated as Boolean values (0 as FALSE; otherwise TRUE) before the operator performs the logical conjunction. The following table lists the values that are returned based on the various combinations of parameter values.

If Expression1 is

If Expression2 is

Return value is

TRUE

TRUE

TRUE

TRUE

FALSE

FALSE

FALSE

TRUE

FALSE

FALSE

FALSE

FALSE

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft