MicroStrategy ONE

Unary minus (U-)

Returns the absolute value of a negative value or the negative value of a positive value.

Syntax

U-(Arg)

Where:

Arg is an attribute, fact, metric representing a list of numbers, or a function that returns numbers and big decimals.

Example

A metric is defined as:

U-(Profit)

This metric changes the sign of the profit value. If the profit value is negative, it returns a positive value. If the profit value is positive, it returns a negative value.