Comment on page
List of Functions
Examples:
FORMAT('{0} of {1}', item.number, data.total)
FORMAT('{} of {}', item.number, data.total)
Summary:
Returns string with arguments inserted into template placeholders.
template
Template with placeholders for arguments
argument1: – optional, repeatable
The value to insert into template placeholder
Examples:
NUMBER_FORMAT(item.amount, 'metric_prefix')
NUMBER_FORMAT(item.price, 'currency', 2)
NUMBER_FORMAT(item.complete, 'percentage')
NUMBER_FORMAT(item.order, 'order')
NUMBER_FORMAT(item.size, 'file_size', 2)
NUMBER_FORMAT(item.amplitude, 'exponential', 4)
Summary:
Returns string representation of number using given format
value
Number value
format – optional
metric_prefix, currency, percentage, order, file_size, or exponential
fraction - optional
Max fractional part, default is 2
Example:
IF(item.approved, 'Approved', 'Not approved')
Summary:
Returns one value if a logical expression is TRUE and another if it is FALSE
logical_expression
An expression or variable containing an expression that represents some logical value, i.e. TRUE or FALSE, or an expression that can be coerced to a logical value
value_if_true
The value the function returns if logical expression is TRUE
value_if_false
The value the function returns if logical_expression is FALSE
Example:
AND(item.approved, NOT(item.processed))
Summary:
Returns TRUE if all of the provided arguments are logically true, and FALSE if any of the provided arguments are logically false
logical_expression1
An expression or variable containing an expression that represents some logical value, i.e. TRUE or FALSE, or an expression that can be coerced to a logical value
logical_expression2
More expressions that represent logical values
Example:
XOR(item.approved, item.processed)
Summary:
Returns TRUE if an odd number of the provided arguments are logically true and FALSE, if an even number of the arguments are logically true
logical_expression1
An expression or variable containing an expression that represents some logical value, i.e. TRUE or FALSE, or an expression that can be coerced to a logical value
logical_expression2 – repeatable
More expressions that represent logical values
Examples:
FLOOR(2.56)
FLOOR(2.56, 0.1)
Summary:
Rounds a number down to the nearest integer multiple of specified significance factor
value
The value to round down to the nearest integer multiple of factor
factor – optional
The number to the multiples of which the value will be rounded
Example:
AVERAGE(item.morning, item.afternoon, item.evening)
Summary:
Returns the numerical average value of a dataset, ignoring text
value1
The first value or range to consider when calculating the average value
value2 – optional, repeatable
Additional values or ranges to consider when calculating the average value
There are also Date & Time functions and Permission functions.
Last modified 7mo ago