MicroStrategy ONE
Abs (Absolute Value)
Returns the absolute value of a given number. The absolute value of a number is the number without a sign. This is a single-value function.
Syntax
Where:
Argument
is a metric representing a list of real numbers.
Example
This simple example show the results of executing the Abs function on a list of values. Assuming you have a metric that represents deposit and withdrawal amounts, the function operates as follows:
Abs(Deposit_Withdrawal)
where Deposit_Withdrawal
is the following list of values: +756.25, -315, +145, -980.35, -75, +1250.78, +560. The resulting value list is 756.25, 315, 145, 980.35, 75, 1250.78, 560. For another example of using the Abs function, see Example 1: Transformed fact.