ROUND

Usage

Use this function to round a decimal number to its closest integer value

Category	Function	Type	Where to use	Argument statement
FUNCTION	SERVER ROW	NUMERIC		.VALUE

Syntax

=ROUND(Value)

Arguments

Value any cell value (#Storage_Name.Field_Name.VALUE or .OLDVALUE), constant or function-returned numeric value

Return Value

Integer

Examples

Example 1

Formula
=ROUND(10.5)

Description
Round 10.5 to its closest integer value

Result
10

Example 2

Formula
=ROUND(10.6)

Description
Round 10.6 to its closest integer value

Result
11

Example 3

Formula
=ROUND(#StorageExample.Number.VALUE)

Description
Round value of the column values Number in the StorageExample to its closest integer value

Result
Integer