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,SalesPlan)
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.
