Table of Contents

CEILING

Specification Value
Description Returns the smallest integer greater than or equal to a specified number.
Parameter 1 Name Number1
Parameter 1 Type double or decimal
Parameter 2 Name -
Parameter 2 Type -
Parameter 3 Name -
Parameter 3 Type -
Return value The nearest integer which is larger than Number1.

Example:

Let's get the smallest integer greater than or equal to the quantity of a sales order line:

10:CEILING ATTRIB:QuantityValue                  

OUTPUT:
If 'QuantityValue = 14.15', the output will be '15'.
If 'QuantityValue = 14', the output will be '14'.

Note

The repository of the attribute is Crm.Sales.SalesOrderLines