Skip to content
For the complete documentation index, see llms.txt. This page is also available as Markdown.

Number functions

Function

Description

Example Expression

Example Result

Min(a, b)

Returns the lesser of a and b

Min(1, 2)

1

Max(a, b)

Returns the greater of a and b

Max(1, 2)

2

Ceil(x)

Returns the value of x rounded up to the nearest integer

Ceil(1.2)

2

Floor(x)

Returns the value of x rounded down to the nearest integer

Floor(1.5)

1

Round(x)

Returns the value of x rounded to the nearest integer

Round(1.8)

2

Pow(x,y)

Returns the result of x raising to the power y.

Pow(8,3)

"512"

Format(x, pattern)

Formats x as a string, using the given pattern. See Formats

Format(0.33333333, "F")

"0.33"

Str(x)

Changes the numeric variable x into a string value. This is rarely necessary as Flow automatically coerces numeric values into string value.

Str(7)

"7"

Val(x)

Changes the string variable x into a numeric value. This is rarely necessary as Flow automatically coerces string values into numeric value.

Val(7)

"7"

IsNumber(x)

Returns a value indicating whether 'x' is a number.

IsNumber("hello")

false

IsNaN(x)

Returns a value indicating whether 'x' is a "not a number" value (usually originating in a null value from a database)

IsNumber(myRecord.x)

N/A

Mathematical expressions

FlowScript supports algebraic expressions using common mathematical operators and parenthesized expressions. For example, the expression:

{x + 1}

...will print out as the value of variable x plus one (provided the variable x has a content which can be interpreted as a number).

Numeric literals (e.g. the 1 in the expression {x + 1}) can be positive or negative, integer or decimal. For decimals, always use the dot character, e.g. 1.5, whether or not your Flow environment is used in a language/region where the comma is used as decimal separator. Note, however, that the numeric content of variables (as opposed to literals) is interpreted less restrictively; both the comma and the period can be used as a decimal separator. This ensures that Flow works with user-input values in regions using a decimal comma (such as Scandinavia) as well as regions using a decimal point (such as the US).

Mathematical operators

The following listing contains all the algebraic operators available in FlowScript.

Plus (+)

Adds two numbers. If the left side value (L) is a date and the right side value (R) is a number, the expression returns a new date representing L with R number of days added.

Expression

Result

a + b

If a is a number, the sum of variables a and b; if a is a date, a new date representing a plus b days.

now() + 1

A date variable representing tomorrow.

Minus (-)

Subtracts two numbers. If the left side value (L) is a date and the right side value (R) is a number, the expression returns a new date representing L with R number of days subtracted.

Expression

Result

a - b

If a is a number, the difference between variables a and b; if a is a date, a new date representing a minus b days.

now() - 1

A date variable representing yesterday.

Multiplication and Division (* /)

Multiplies or divides two numbers.

Expression

Result

a * b

a multiplied by b

a * 1.5 * b

a multiplied by 1.5 multiplied by b

a / 10

a divided by 10

Last updated

Was this helpful?