FLOOR

Returns the value from a numeric field rounded down to the next whole number.

FLOOR ( <field_name or value> )
  • field_name or value: The numeric field or value to perform the calculation on.

Example: create a field at the ACCOUNT that returns the account balance rounded down to the next whole number.

FLOOR( [Account.Acct Balance] )