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.
SUBTRACT(value1, value2, ... valueN)value1: The value from which the other values are subtracted.value2, ... valueN (Optional): Additional values or node references to subtract from the first value.Returns the result after subtracting the specified values.
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.
