DIVISION

The DIVISION function returns the division of all numbers in the arguments, which can be numbers or node references.

Syntax

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

Arguments

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

Example

Consider the below example where Revenue and Cost of Sales Is given. Calculate Gross Profit%.

	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
Revenue	31400	32600	35100	32600	31900	33700	35000	31700	33600	34100	32500	33000
Cost of Sales	24300	25300	25800	23300	27300	28400	21200	26900	25700	24200	28900	27300

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

DIVISION(([Revenue]-[Cost of Sales]),[Revenue])

To show the values in percentage, scale should be set in Percentages.

Result

	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
Gross Profit %	22.61%	22.39%	26.50%	28.53%	14.42%	15.73%	39.43%	15.14%	23.51%	29.03%	11.08%	17.27%