Operators

Like most languages, PQL and MDX have various types of functional operators covering arithmetic, comparison, and logical operations.

Arithmetic

 

For operating on numeric values and data points:

+

Add numerics

+

Concatenate (join) strings

-

Subtract numerics

*

Multiply numerics

/

Divide numerics

%

Modulus numerics (supported in PQL only, not MDX)

   

Comparison

 

Used for deriving comparative expressions:

<

Less than

<=

Less than or equal to

>

Greater than

>=

Greater than or equal to

=

Equal to

!=

Not Equal to

   

Logical

 

Used for composite logical and comparative expressions:

&&

And

||

Or