Numeric Functions

Updated 1 year ago by dustin keir

Numeric Functions

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.
  • Floor – Rounds a number down to the nearest integer or down to a specified number of decimal points.
  • Round – Rounds a number to the nearest integer or to a specified number of decimal points.

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.


How did we do?