ROUND

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

Syntax

ROUND(value) - > number

Arguments

Arguments	Datatype	Description
value	Number/Node reference	This is the number or node values which you want to round off. This is a required argument.

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.

	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
Sales	69700.64	72700	76500.93	70200.69	71500.72	83900.54	70000.721	69500.43	74200.94	67700.38	78450.82	68950.43
Cost of Sales	43400.36	44300.68	46700.93	45300.25	43600.54	46900.39	44200.452	42800.81	45900.18	43800.06	47200.67	41000.32

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

ROUND(SUBTRACT([Sales],[Cost of Sales]))

Result

	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
Gross Profit	26300	28399	29800	24900	27900	37000	25800	26700	28301	23900	31250	27950