 # Operators (MDX)

The following table lists the available operators and their descriptions.

### Description

Comparison

`        Equal To (=)                    Compare two MDX expressions:                                                NULL = false is true                                                NULL = 0     is true        Not Equal To (<>)               Compare two MDX expressions:                                                NULL <> false is false                                                NULL <> 0     is false        Less Than (<)                   Compare two MDX expressions.        Less Than or Equal To (<=)      Compare two MDX expressions.        Greater Than (>)                Compare two MDX expressions.        Greater Than or Equal To (>=)   Compare two MDX expressions.        `

Comparison (Strict)

`        Equal To (==)                   Similar to the 'Equal To' operator except that:                                                NULL == false is false                                                NULL == 0     is false        Not Equal To (!=)               Similar to the 'Not Equal To' operator except that:                                                NULL != false is true                                                NULL != 0     is true        Less Than (<<)                  Similar to the 'Less Than' operator except that:                                                0, false, "" are not considered as NULL        Less Than or Equal To (<<=)     Similar to the 'Less Than or Equal To' operator except that:                                                0, false, "" are not considered as NULL        Greater Than (>>)               Similar to the 'Greater Than' operator except that:                                                0, false, "" are not considered as NULL        Greater Than or Equal To (>>=)  Similar to the 'Greater Than or Equal To' operator except that:                                                0, false, "" are not considered as NULL        `

Logical

`        And (AND)                       Logical and operation.        Or (OR)                         Logical or operation.        Not (NOT)                       Logical not operation.        Xor (XOR                        Logical xor operation.        Is (IS)                         Same MDX entities (www).        `

Mathematical

`        Add (+)                         Adds two scalar entities. Note that string entities are concatenated.        Subtract (-)                    Subtracts two scalar entities or unary negative operator.        Multiply (*)                    Multiplies two scalar entities.        Divide (/)                      Divides two scalar entities.        Power (^)                       Raises one scalar entity by a number.        `

Others

`        Crossjoin (*)                   Cross product of two sets (www).        Except (-)                      Difference between two sets (www).        Union (+)                       Union of two sets removing duplicates (www).        Range (:)                       A set of members between two members (www).        `