8,981
edits
Changes
no edit summary
Example:
ABS("Price" / "Quantity")
==== AVG function ====
Returns the average of the values of a sequence of values. It can be used to return the average of different values of the same row of tables.
Syntax:
AVG(<expression 1>; <expression 2>; ...)
Example:
AVG("Taxes"; "Profit"; "Cost")
==== BETWEEN function ====
Checks whether a value is within the limits of the parameters used. Return true or false.
Syntax:
BETWEEN(<expression to be tested>; <initial limit>; <end limit>)
Example:
BETWEEN("Date Issued"; '01/01/2019'; '31/12/2019')
==== IF ELSE function (If .... Otherwise ...) ====
Tests a Boolean expression and applies a condition to true or another condition to false. You need three parameters, separated by semicolons (;). The first parameter is the expression to be tested, the second the value to be applied in case of true, and the third to be applied in case of false.
Syntax:
IF(<expression to be tested>; <expression if true>; <expression if false>)
Examples:
IF(BETWEEN("Value";0;100);10;250)
IF("Profit" == 0;0;"Profit" + "Taxes")
==== LOG function ====
Returns the logarithm of a number on a defined basis. It can be used with only one parameter, in this case the neperian (natural) logarithm is used . If two parameters are used, the second server to inform the base to be used by the logarithm.
Syntax:
LOG(<expression>;<base>)
Examples:
LOG("Profit")
LOG("Price";2)
==== MAX function ====
Returns the largest value between two values.
Syntax:
MAX(<expression 1>;<expression 2>)
Example:
"Value" / MAX("Quantity";1)
==== MIN function ====
Returns the smallest value between two values.
Syntax:
MIN(<expression 1>; <expression 2>)
Example:
"Value" / MIN("Cost"; 100)
</translate>