Floor (Expression Function)


The Floor function (FLOOR) rounds a number down to the nearest multiple of a certain other number.


The Floor function has two parameters, one of which:


Allowed Inputs: field value or number

The first required parameter is the number that will be rounded down. Either use the use the Query Builder to choose a field that contains the value or use type a value to enter a number.


Allowed Inputs: field value or a number

The second optional parameter of the Floor function is the number that represents the multiple that the value will be rounded up to. If no value is provided then 1 will be used and the value will be rounded up to the nearest integer value. 0 is an illegal value for the step. Either use the query builder or the type a value option to enter a number.


The output of the Ceiling function is a number representing the value rounded up to the nearest multiple of the step value. Positive numbers will round away from zero and negative numbers will round towards zero.


For example CEILING(-5.33,1) would result in -5 and CEILING(5.33,1) will result in 6. The step does not have to be in whole integer increments for example CEILING(5.33,.5) would result in 5.5. The step can also be larger than single digits for example CEILING(15.33, 10) would result in 20.

expression function - floor.txt · Last modified: 2016/09/14 14:19 (external edit)
Copyright WorkXpress, 2023