FLOOR

Description

FLOOR returns the value of the given parameter, always rounded down to the nearest whole number.

‚Äč

Example

FLOOR(p.total_fee)

This expression returns the total fee that applies to a person, always rounded down to the nearest whole number, even if the decimal value is .50 or higher.

If the total fee for a client comes out at USD 421.68, CEIL(p.total_fee) will return USD 421.