- Introduction to WorkXpress
- Building Your Application
- Examples and Best Practices
- Technical Manual

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

— |
expression function - ceiling [2016/09/14 14:19] (current) |
||
---|---|---|---|

Line 1: | Line 1: | ||

+ | ====== Ceiling (Expression Function) ====== | ||

+ | ===== Purpose ===== | ||

+ | The **Ceiling** function (CEILING) rounds a number up to the nearest multiple of a certain other number. | ||

+ | |||

+ | {{::ceiling_initial.png?direct&600|}} | ||

+ | |||

+ | ===== Parameters ===== | ||

+ | The **Ceiling** 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 up. 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 **Ceiling** 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. |

Copyright WorkXpress, 2019