# ROUND

The ROUND function calculates rounded value of the specified number or node.

### Syntax

ROUND(value) - > number

### Arguments

<table><thead><tr><th width="159">Arguments</th><th width="148">Datatype</th><th>Description</th></tr></thead><tbody><tr><td>value</td><td>Number/Node reference</td><td>This is the number or node values which you want to round off. This is a required argument.</td></tr></tbody></table>

### Remarks

If the decimal value is less than 5, it will round down and if it is 5 or more it will round up.

### Example

Consider this example.

<table><thead><tr><th width="84"></th><th width="131">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;">Sales</mark></td><td>69700.64</td><td>72700</td><td>76500.93</td><td>70200.69</td><td>71500.72</td><td>83900.54</td><td>70000.721</td><td>69500.43</td><td>74200.94</td><td>67700.38</td><td>78450.82</td><td>68950.43</td></tr><tr><td><mark style="color:orange;">Cost of Sales</mark></td><td>43400.36</td><td>44300.68</td><td>46700.93</td><td>45300.25</td><td>43600.54</td><td>46900.39</td><td>44200.452</td><td>42800.81</td><td>45900.18</td><td>43800.06</td><td>47200.67</td><td>41000.32</td></tr></tbody></table>

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

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

### **Result**

<table><thead><tr><th width="84"></th><th width="131">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>Gross Profit</td><td>26300</td><td>28399</td><td>29800</td><td>24900</td><td>27900</td><td>37000</td><td>25800</td><td>26700</td><td>28301</td><td>23900</td><td>31250</td><td>27950</td></tr></tbody></table>