ROUND

This will round an expression to a number of decimal places without adding formatting commas to the number.

The result can then optionally be added in to a total.

Number	Name	Default	Type	Description
1	expression	0	Expression	An Expression to be Evaluated
2	places	2	Integer	The number of decimal places
3	total	0	Integer	Total to add the Evaluated rounded expression to.

<!-- Returns the rounded value to two decimal places by default -->
{ROUND(2.3456)}<br />
<!-- Returns the rounded value to three decimal places -->
{ROUND(2.3456, 3)}<br />
<!-- Returns the rounded value to two decimal places and adds it to the total variable 1 -->
{TOT_RESET}
{ROUND(2.3456,, 1)}<br />
{TOT(1)}<br />
<!-- Returns the rounded value to two decimal places and adds it to the total variable 1 -->
{ROUND(3.4567,, 1)}<br />
{TOT(1)}

2.35
2.346
2.35
2.35
3.46
5.81

to add a Comment.

ULTIMATE DATABASE

HIGH QUALITY BESPOKE SOFTWARE DEVELOPMENT TOOL

ROUND

Example