SUBTRACT

The SUBTRACT function returns the difference of all values in the arguments.

Syntax

SUBTRACT(value1, ...valueN?) - > number

Arguments

Arguments	Datatype	Description
value1	Number/Node reference	The first node or number to be subtracted. This is a required argument.
...valueN?	Number/Node reference	The additional nodes or numbers to be subtracted. These are optional arguments.

Example

Consider the below example where we have Revenue and expenses data. The objective is to calculate the profit.

Periods	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
Revenue	300	450	367	408	832	671	700	260	572	903	534	671
Sales	180	200	238	174	286	319	265	136	220	260	300	315
Other revenue	120	250	129	234	546	352	435	124	352	643	234	356
Expenses	170	173	360	264	174	184	582	273	503	296	295	484
Rent	50	50	50	50	50	50	50	50	50	50	50	50
Other expenses	120	123	310	214	124	134	532	223	453	246	245	434

To achieve this, the following formula should be written in the [Profit] node.

SUBTRACT([Revenue],[Expenses])

Result

Profit	130	277	7	144	658	487	118	-13	69	607	239	187