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