Number and currency expressions
Modified 4 years ago
Neil
Number and currency expressions are similar. However, many functions, methods, and operators may not work when evaluating numbers and currencies together.
If you use multiple currency fields, make sure they are the same type. Rating and slider fields can be used as number fields in expressions.
Example fields
We’ll use these sample fields in the expressions below.
FieldID | Type | Value |
num1 | Number | 10 |
num2 | Number | 22.45 |
cur1 | Currency | $10 |
Number and currency functions
Functions go at the start of the expression.
Function | Data type | Description | Syntax | Output |
Rand | Number | Generates a random number. | Rand() | 0.449218421 |
RandBetween | Number | Generates a random number between two values. | RandBetween(1, 10) | 4 |
Mod | Number or Currency | Shows the remainder when the dividend is divided by the divisor. If the dividend is a currency, the result is also a currency. | Mod(num1, 3) Mod(cur1, 3) | 1 $1 |
Min | Number or Currency | Shows the minimum value of a set of numbers. | Min(num1, num2) | 10 |
Max | Number or Currency | Shows the maximum value of a set of numbers. | Max(num1, num2) | 22.45 |
Methods
Methods come after the fieldID and are called up with a dot operator.
Function | Description | Syntax | Output |
round | Rounds a number up or down. Add the number of decimal places you want. | num2.round() num2.round(1) | 22 22.5 |
roundup | Always rounds a number up. Add the number of decimal places you want. | num2.roundup() num2.roundup(1) | 23 22.5 |
rounddown | Always round a number down. Add the number of decimal places you want. | num2.rounddown() num2.rounddown(1) | 22 22.4 |
ceil | Rounds up a number to the nearest multiple of the unit given. If no value is given, it is treated as 1. | num2.ceil(5) | 25 |
floor | Rounds down a number to the nearest multiple of the unit given. | num2.floor(5) | 20 |
abs | Shows the absolute value of a number. | num2.abs() | 22.45 |
code | Shows the currency code in a text field. | cur1.code() | USD |
Operators
There are five arithmetic operators in Kissflow:
- Addition (+)
- Subtraction (-)
- Multiplication (*)
- Division (/)
- Exponents (^)
Expressions with arithmetic operators can use integers or fields.
Using operators
Here are all the ways that you can evaluate fields.
Field 1 | Field 2 | Operator | Resulting type |
Number | Number | +, -, *, / | Number |
Number | Integer | +, -, *, /, ^ | Number |
Currency | Currency (same) | +, - | Currency |
Currency | Number/Integer | *, / | Currency |
Converting data types
Here are some ways to convert data types using numbers.
Name | Description | Syntax | Output |
value | Converts a currency value to a number value. | cur1.value() | 10 |
Number | Converts a text value to a number. E.g. the value of text1 is “10”. | Number(text1) | 10 |
Currency | Converts a number value to a specific currency. | Currency(num1, GBP) | £ 10 |
convert | Converts one currency into another type with a static exchange rate.1 | cur1.convert(.90, “EUR”) | EUR €9.00 |
1. To use real-time exchange rates, use a remote lookup field.
Method | Syntax | Input type | Output type | Explanation |
extractNumber | Remotelookup_Fieldname.extractNumber (<path,<index>) | Remotelookup_Fieldname: JSON OBJECT<path>: TEXT (valid json path)<index>: NUMBER | LIST{NUMBER}NUMBER | Extracts and returns a number array from the JSON object as filtered by the provided json path. If the index is provided then the number in the particular index is extracted. |
