106
edits
Changes
no edit summary
==== Value type operand ==== <!--T:7-->
Are numeric values of the float type (Real numbers domain). These values allow the use of a an integer and a fraction part, separated by the dot (.) character (decimal separator).
'''Examples''': 1, 1.05, 2.55;
==== Identifier type operand ==== <!--T:11-->
Are values that represents represent a field or variable in the expression. Used to make reference to data source columns, delimited by double quotes (").
'''Examples''': "City.City", "Product.Product";
<!--T:21-->
The relational expressions compare two operands (value or another expression) two to evaluate if a condition is ''true'' or ''false''. Usually used with decision functions, like the ''IF''.
==== Equal (==) ==== <!--T:22-->
==== Greater than (>) ==== <!--T:24-->
Return ''true'' if the the first expression is greater than the second expression and ''false'' otherwise. Represented by the greater operator (>).
Syntax: ''<expression> > <expression>''.
'''Examples''': "Order Date" > '01/01/2011';
==== Greater or equal than (>=) ==== <!--T:25-->
Return ''true'' if the the first expression is greater than or equal to the second expression and ''false'' otherwise. Represented by the greater or equal operator (>=).
Syntax: ''<expression> >= <expression>''.
'''Examples''': IF("Order Date" >= '01/01/2011';"Order Date";0);
==== Lesser than (<) ==== <!--T:26-->
Return ''true'' if the the first expression is lesser than the second expression and ''false'' otherwise. Represented by the lesser operator (<).
Syntax: ''<expression> < <expression>''.
'''Examples''': "Profit" < '0';
==== Lesser or equal than (<=) ==== <!--T:27-->
Return ''true'' if the the first expression is lesser than or equal to the second expression and ''false'' otherwise. Represented by the lesser or equal operator (<=).
Syntax: ''<expression> <= <expression>''.
'''Examples''': IF("Order Date" <= '01/01/2011';"Order Date";0).
<!--T:29-->
The logical expressions group two operands (boolean type or another expression) to compose a logic expression, with the objective to evaluate two boolean operands relation into a ''true'' or ''false'' result. Usually used with decision functions, like the ''IF'' , and with relational expressions.
==== Not (!) ==== <!--T:32-->
Performs the denial logical operation for a boolean value. If the operand are is ''true'' the ''NOT'' convert it to ''false'' (and the other way around). Represented by the ''NOT'' operator (!).
Syntax: ''! <expression>''.
'''Examples''': IF(!BETWEEN("Date", '01/01/2013', '31/12/2013');'Not 2013';'2013').
==== Between ==== <!--T:38-->
Check if a value is inside within the boundaries of the parameters values.
Syntax: ''BETWEEN(<expression_to_test>;<expression_bottom_limit>;<expression_top_limit>)''. Need three parameters (of any data type, but
the three must be from the same type) and returns a boolean, ''true'' if value is inside the boundaries and ''false'' if not.
==== Random ==== <!--T:44-->
Returns a an aleatory number inside the boundaries of the limit values.
Syntax: ''RANDOM(<expression_bottom_limit>;<expression_top_limit>)''. Need two parameters, the bottom and the upper limit of the random
number to be generated.
<!--T:47-->
The date functions are operations that use as parameters and return the result of the [[Date|date data type]].
==== Constants list ==== <!--T:48-->
==== First day of ==== <!--T:51-->
Return the first day of a grouping. This function have has two variations:
* '''First way''':
Syntax: ''FIRST_DAY_OF(<constant_grouping>;<expression_date>)''. Need two parameters, the first is the constant grouping in which you
==== Last day of ==== <!--T:52-->
Return the last day of a grouping. This function have has two variations:
* '''First way''':
Syntax: ''LAST_DAY_OF(<constant_grouping>;<expression_date>)''. Need two parameters, the first is the constant grouping in which you
<!--T:58-->
Special variables can be use used with the expressions.
<!--T:59-->