Number and currency expressions

Manju_Lekha_Singaram
updated 1 yr ago

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(10, "GBP")	£ 10
Currency from text	This function converts a string value to a specified currency. You should include a space between the integer value and the currency code as part of the syntax. Note: This function is only supported in the integration configuration forms.	currencyFromText("10 USD")	$ 10
convert	Converts one currency into another type with a static exchange rate.¹	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.