CEILING

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

CEILING( <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 up to the next whole number.

CEILING( [Account.Acct Balance] )