Differences

This shows you the differences between two versions of the page.

Link to this comparison view

expression function - floor [2016/09/14 14:19] (current)
Line 1: Line 1:
 +====== Floor (Expression Function) ======
  
 +===== Purpose =====
 +The **Floor** function (FLOOR) rounds a number down to the nearest multiple of a certain other number. ​
 +
 +{{:​floor_initial.png?​direct&​600|}}
 +
 +===== Parameters =====
 +The **Floor** function has two parameters, one of which:
 +
 +==== Value ====
 +
 +Allowed Inputs: [[Field|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.
 +
 +==== Step ====
 +
 +Allowed Inputs: [[Field|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.
 +
 +
 +===== Output =====
 +
 +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.
 +
 +===== Example =====
 +
 +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, 2019