8,981
edits
Changes
no edit summary
==== Multiplication (*0 ) ====
Multiplies two value operands or another expression result. Represented by the multiplication charecter ''*''.
Example:
IF("Product" == "#null";0;20)
==== Different (!=) ====
It compare if two operands are different, returning true if they were different or false if equal. Represented by the differente operator ''!=''.
Syntax:
<operating or expression result> '''!=''' <operating or expression result>
Example:
IF("Product" != 'Lasagna';0;20)
==== Greater than (>) ====
Compares if the first operator (from the left) is greater than the second operator (from the right), returning true if it is greater and false if it is lesser or equal. Represented by the greater operator ''>''.
Syntax:
<operating or expression result> '''>''' <operating or expression result>
Example:
IF("Gross Value" > 1000;1;0)
==== Greater or equal to (>=) ====
Compares if the first operator (from the left) is greater or equal to the second operator (from the right), returning true if it is greater or equal and false if it is lesser. Represented by the greater or equal operator ''>=''.
Syntax:
<operating or expression result> '''>=''' <operating or expression result>
Example:
IF("Gross Value" >= 2500;100;0)
==== Less than (<) ====
Compares if teh first operator (from the left) is lesser than the second operator (from the right), returning true if it is lesser and false if it is greater or equal. Represented by the Lesser operator ''<''.
Syntax:
<operating or expression result> '''<''' <operating or expression result>
Example:
IF("Gross Value" < 100;50;200)
==== Less or equal to (<=) ====
Compares if the first operator (from the left) is lesser or equal to the second operator (from the right), returning true if it is lesser or equal and false if it is greater. Represented by the lesser or equal operator ''<=''.
Syntax:
<operating or expression result> '''<=''' <operating or expression result>
Example:
IF("Gross Value" <= 500;100;0)
=== Logical Expressions ===
Logical expressions group together two operands (Boolean or other expression) to make up a logical expression, in order to evaluate the relationship of two Boolean operators to a true or false result. This type of expression is usually used for decision making, such as IF and with relational expressions.
==== And Operator (&&) ====
Executes the logical operation ''AND'' between two Boolean values. Both values must return true so that the result of the operation is true. Represented by the ''&&'' operator.
Syntax:
<expression> && <expression>
Examples:
IF(("Price" > 0) && ("Seller" == 'John Snow');450;0)
IF(("City" != "#null") && ("Product" != 'Lasagna');1;0)
==== Or Operator (||) ====
Performs the logical ''OR'' operation between two Boolean values. A two values must be true so that the result of the operation is true. Represented by the operator ''||''.
Syntax:
<expression> || <expression>
Examples:
IF(("Price" > 1000) || ("Profit" >= 50);75;55)
IF(("City" != "#null") || ("Product" != 'Lasagna');1;0)
==== Denial Operator (!) ====
Performs the logical negation operation for a boolean value. If the result of the operation is true the negation operator converts to false and vice versa. Represented by the operator ''!''.
Syntax:
!<expression>
Example:
IF(!BETWEEN("Delivery Date"; '01/01/2015'; '31/12/2015');2016;2015)
=== Auxiliary Functions ===
Basic helper functions are standard system functions and implement useful features for composing complex expressions.
==== ABS function ====
Function that returns the absolute numeric value of a base numeric value.
Syntax:
ABS(<value operator or expression>)
Example:
ABS("Price" / "Quantity")
</translate>