ROUND()

From Recital Documentation Wiki
Jump to: navigation, search

Purpose

Function to return rounded numeric


Syntax

ROUND(<expN1> [,<expN2>])


See Also

CEILING(), FLOOR(), INT(), LENNUM(), SET DECIMALS, SET FIXED, TRANSFORM()


Description

The ROUND() function rounds the numeric expression <expN1> to <expN2> decimal places. If <expN2> is omitted then it is taken as zero. If the SET FIXED command is ON, <expN2> can not be greater than the number of decimal places specified by the SET DECIMALS command.


Example

? round(3.467)
      3.00
? round(3.467,1)
      3.50
? round(3.467,2)
      3.47


Products

Recital, Recital Server