# 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

<table><thead><tr><th width="159">Arguments</th><th width="148">Datatype</th><th>Description</th></tr></thead><tbody><tr><td>value1</td><td>Number/Node reference</td><td>The first node or number to be divided. This is a required argument.</td></tr><tr><td>...valueN?</td><td>Number/Node reference</td><td>The additional nodes or numbers to be divided. These are optional arguments.</td></tr></tbody></table>

### Example

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

<table><thead><tr><th width="97"></th><th width="103">Jan</th><th width="64">Feb</th><th width="64">Mar</th><th width="64">Apr</th><th width="64">May</th><th width="64">Jun</th><th width="64">Jul</th><th width="64">Aug</th><th width="64">Sep</th><th width="64">Oct</th><th width="64">Nov</th><th width="64">Dec</th></tr></thead><tbody><tr><td><mark style="color:purple;">Revenue</mark></td><td>31400</td><td>32600</td><td>35100</td><td>32600</td><td>31900</td><td>33700</td><td>35000</td><td>31700</td><td>33600</td><td>34100</td><td>32500</td><td>33000</td></tr><tr><td><mark style="color:orange;">Cost of Sales</mark></td><td>24300</td><td>25300</td><td>25800</td><td>23300</td><td>27300</td><td>28400</td><td>21200</td><td>26900</td><td>25700</td><td>24200</td><td>28900</td><td>27300</td></tr></tbody></table>

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

<mark style="color:blue;">**`DIVISION`**</mark>**`((`**<mark style="color:purple;">**`[Revenue]`**</mark>**`-`**<mark style="color:orange;">**`[Cost of Sales]`**</mark>**`),`**<mark style="color:purple;">**`[Revenue]`**</mark>**`)`**

{% hint style="info" %}
To show the values in percentage, scale should be set in Percentages.
{% endhint %}

### **Result**

<table><thead><tr><th width="185"></th><th width="135">Jan</th><th width="134">Feb</th><th width="139">Mar</th><th width="140">Apr</th><th width="64">May</th><th width="64">Jun</th><th width="64">Jul</th><th width="64">Aug</th><th width="64">Sep</th><th width="64">Oct</th><th width="64">Nov</th><th width="64">Dec</th></tr></thead><tbody><tr><td>Gross Profit %</td><td>22.61%</td><td>22.39%</td><td>26.50%</td><td>28.53%</td><td>14.42%</td><td>15.73%</td><td>39.43%</td><td>15.14%</td><td>23.51%</td><td>29.03%</td><td>11.08%</td><td>17.27%</td></tr></tbody></table>