SUBTRACT

The SUBTRACT function accepts a series of values, subtracts them, and returns a number.

Syntax

subtract(value1,value2...valueN)

Arguments

value1, value2 – Can be numbers or node references.

Example

Use the subtract function to calculate the difference between planned and actual values, as shown in the example.

SUBTRACT([Actuals]-[Plan])
SUBTRACT(25,4,10,16)