Minus (-)

Returns the difference between two values.

Syntax

Arg1 - Arg2

Where:

Arg1 and Arg2 are attributes, facts, metrics representing a list of numbers, big decimals, date/time, or functions that return numbers or big decimals. Both Arg1 and Arg2 must be of the same data type, with the exception if Arg1 is a Date data type. In this case, Arg2 must be a number.

Example

A metric is defined as:

Revenue - Freight

This metric returns the difference between the revenue and freight charges.