^ (exponentiation) (PEL)
This operator performs an arithmetic operation that returns the value of a specified number raised to the power of a second number.
Expression1 ^ Numeric
Operands
- Expression1
A valid PerformancePoint Expression Language (PEL) expression that returns a numeric value.
- Expression2
A valid PEL expression that returns a numeric value.
Return Value
The numeric value that is the result of Expression1******to the power of Expression2.
Remarks
If both Expression1 and Expression2 are not NULL, the operator returns the same value for MdxQuery implementation and SQL implementation.
If one of the parameter expressions evaluates to a null value, the ^ operator has different behavior for rules with MdxQuery implementation and rules with SQL implementation. The following table describes the return values for the operator when one parameter evaluates to a null value.
Expression1 value | Expression2 value | MdxQuery implementation | SQL implementation |
---|---|---|---|
NULL |
Not NULL |
0 |
Nothing |
Not NULL |
NULL |
1 |
Nothing |
NULL |
NULL |
Rule fails at runtime |
Nothing |