MicroStrategy ONE

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

Abs(Argument)

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.