SUBTRACT

The SUBTRACT function subtracts a series of values and returns the resulting number. It deducts subsequent values from the first value provided and is commonly used in calculations where differences between numbers need to be determined.

Syntax

SUBTRACT(value1, value2, ... valueN)

Arguments

• value1: The value from which the other values are subtracted.
• value2, ... valueN (Optional): Additional values or node references to subtract from the first value.

Return value

Returns the result after subtracting the specified values.

Example

SUBTRACT(Sales, Sales Plan)

In this example, the Sales Variance measure is created using the SUBTRACT function, which returns the result of subtracting the values in Sales Plan from Sales.