{{sidenavigation.sidenavigationExpandLabel}}
{{getMsg('Help_YouAreHere')}}: {{page.title}} {{page.title}}
{{$root.getMsg("downLoadHelpAsPdf")}} {{helpModel.downloadHelpPdfDataStatus}}

Truncate

Discards every digit of to the right of the y'th digit of x. Y is an optional parameter, if it is not supplied, 0 is taken, that is: Truncate(x) is the same as Truncate(x,0).

Usage:

Truncate( x )
Truncate( x, #places )

Parameters:

x A (decimal) number
#places Whole number of decimal places [OPTIONAL...default: 0].

Returns:

Numeric value

Examples:

truncate( 3.8 )      //3
truncate( 1.2 )      //1
truncate( 4.5 )      //4
truncate( 3.14, 1)   // 3.1
truncate(23.112, -1) // 20.0

See also:

i-net Clear Reports
This application uses cookies to allow login. By continuing to use this application, you agree to the use of cookies.


Help - Truncate