Use numeric functions to manipulate numeric values in formula user- defined fields and in rules for mandatory fields. You can add the following functions to formulas using numeric fields.
Ceiling
Rounds a number up to the nearest integer or up to a specified number of decimal points.
Syntax: Ceiling(Number, DecPlace)
Parameters
| Parameter | Data Type | Description |
| Number | Decimal | The numeric value to round. |
| DecPlace | Integer | (Optional) The number of decimal places to round up to. |
Example
Ceiling(2.32, 1)
This example returns 2.4.
Floor
Rounds a number down to the nearest integer or down to a specified number of decimal points.
Syntax: Floor(Number, DecPlace)
Parameters
| Parameter | Data Type | Description |
| Number | Decimal | The numeric value to round. |
| DecPlace | Integer | (Optional) The number of decimal places to round down to. |
Example
Floor(2.36, 1)
This example returns 2.3
Round
Rounds a number to the nearest integer or to a specified number of decimal points.
Syntax: Round(Number, DecPlace)
Parameters
| Parameter | Data Type | Description |
| Number | Decimal | The numeric value to round. |
| DecPlace | Integer | (Optional) The number of decimal places to round to. |
Example
Round(2.45687, 2)
This example returns 2.46.