Rounding Issues > ROUND function

The ROUND function is used in particular in:

▪the formulas of the Field Manager for Minutes and Nomenclatures

▪the Overhead Summary sheet (target option)

Syntax

ROUND(X,-n) means that n digits (units, tens, ..) are set to 0 (e.g., format: xxx,x00.00 if n=2) and the preceding number is adapted (e.g. 646322,32 becomes 650 000).

ROUND(X,n) means that n decimals are kept as are, and the others are set to 0 (e.g., format: xxx,xxx.x0 if n=1).

ROUND(X)=ROUND(X,0)

ROUND(X, Rounding) requests to enforce the Rounding in Minutes

Adaptive Rounding

To take into account the size of the figure to round, you can make the function argument depend on the figure.

Say n is the count of "meaningful" digits we want to show at the detailed level. Insert the following formulas on this level:

Unit value	Qty	Total value	# of digits in the total	Rounded Unit value	Rounded Total value
			=COUNTCHAR(ABS(INT(B3)))	=ROUND(B1,n-B4)	=ROUND(B3,n-B4)