FLOOR: Returning the Largest Integer Less Than or Equal to a Value

How to:

FLOOR returns the largest integer value that is less than or equal to a number.

Syntax: How to Return the Largest Integer Less Than or Equal to a Number

FLOOR(number)

where:

number

Numeric

Is the number whose floor will be returned. The output data type is the same as the input data type.

FLOOR returns the smallest integer larger than the value in GROSS_PROFIT_US:

FLOOR(GROSS_PROFIT_US)

For 225.98, the output is 225.00.

For -30.01, the output is -31.00.

	WebFOCUS