ROUNDDOWN( )

Rounds a number down to a specified number of digits.

Syntax

ROUNDDOWN(number)

ROUNDDOWN(number, dec)

Arguments

number

The number to round down.

dec

The number of digits to round number down to. If you omit dec, ROUND( ) assumes 0.

Returns

A number rounded down to a specified number of digits.

Example

The following example rounds down the numbers in the PriceEstimate field to return an integer. For example, if the PriceEstimate value is 1545.25, ROUNDDOWN( ) returns 1545. If the PriceEstimate value is 1545.90, ROUNDDOWN( ) returns 1545.

ROUNDDOWN([PriceEstimate])

The following example rounds down the numbers in the PriceEstimate field to one decimal place. For example, if the PriceEstimate value is 1545.56, ROUNDDOWN( ) returns 1545.5. If the PriceEstimate value is 1545.23, ROUNDDOWN( ) returns 1545.2.

ROUNDDOWN([PriceEstimate], 1)

The following example rounds the numbers in the PriceEstimate field down to one digit to the left of the decimal point. For example, if the PriceEstimate value is 1545.56, ROUNDDOWN( ) returns 1540. If the PriceEstimate value is 1338.50, ROUNDDOWN( ) returns 1330.

ROUNDDOWN([PriceEstimate], -1)

Copyright Actuate Corporation 2012