MicroStrategy ONE
Power
Returns the value of an input number raised to a given power. This is a single-value function.
Syntax
Where:
Argument is a metric representing a list of base numbers. All real numbers are valid.
Power is the exponent to which Argument is raised.
Usage Notes
If Argument is a negative number and Power is an even number, the result is positive; however, if Argument is negative and Power is an odd number, the result is negative.
Example
These simple examples illustrate the results of using the Power function.
| Function/Result | Calculation |
|
Power(5, 2) = 25 |
5 × 5 = 25 |
|
Power(-5, 2) = 25 |
-5 × -5 = 25 |
|
Power(-5, 3) = -125 |
-5 × -5 × -5 = -125 |
|
Power(4, 3) = 64 |
4 × 4 × 4 = 64 |
|
Power(20,4) = 160000 |
20 × 20 × 20 × 20 = 160000 |