Number functions
Function | Description | Example Expression | Example Result |
| Returns the lesser of a and b |
| 1 |
| Returns the greater of a and b |
| 2 |
| Returns the value of x rounded up to the nearest integer |
| 2 |
| Returns the value of x rounded down to the nearest integer |
| 1 |
| Returns the value of x rounded to the nearest integer |
| 2 |
| Returns the result of x raising to the power y. |
| "512" |
| Formats x as a string, using the given pattern. See Formats |
| "0.33" |
| Changes the numeric variable x into a string value. This is rarely necessary as Flow automatically coerces numeric values into string value. |
| "7" |
| Changes the string variable x into a numeric value. This is rarely necessary as Flow automatically coerces string values into numeric value. |
| "7" |
| Returns a value indicating whether 'x' is a number. |
| false |
| Returns a value indicating whether 'x' is a "not a number" value (usually originating in a null value from a database) |
| N/A |
Mathematical expressions
FlowScript supports algebraic expressions using common mathematical operators and parenthesized expressions. For example, the expression:
...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 |
| 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. |
| 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 |
| 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. |
| A date variable representing yesterday. |
Multiplication and Division (* /)
Multiplies or divides two numbers.
Expression | Result |
| a multiplied by b |
| a multiplied by 1.5 multiplied by b |
| a divided by 10 |
Last updated