Operators
Like most languages, PQL and MDX have various types of functional operators covering arithmetic, comparison, and logical operations.
|
For operating on numeric values and data points: |
|
|
+ |
Add numerics |
|
+ |
Concatenate (join) strings |
|
- |
Subtract numerics |
|
* |
Multiply numerics |
|
/ |
Divide numerics |
|
% |
Modulus numerics |
|
Used for deriving comparative expressions: |
|
|
< |
Less than |
|
<= |
Less than or equal to |
|
> |
Greater than |
|
>= |
Greater than or equal to |
|
= |
Equal to |
|
!= |
Not Equal to |
|
Used for composite logical and comparative expressions: |
|
|
&& |
And |
|
|| |
Or |