1,788
edits
Changes
no edit summary
'''BETWEEN("Date Issued"; '01/01/2019'; '31/12/2019')''' - Returns true if ''Date Issued'' is between ''01/01/2019'' and ''12/31/2019''. Otherwise returns false
==== COUNT function ====<!--T:229-->
<!--T:230-->
Returns number of occurrences (lines) for column or value.
<!--T:231-->
By now this functions works only at Datasource expressions
<!--T:232-->
Syntax:
COUNT(<expression>)
'''COUNT("Product")''' - Returns number of occurrences (lines) of products
==== COUNT_DISTINCT function ==== <!--T:233-->
<!--T:234-->
Returns number of unique occurrences (lines) for column or value.
<!--T:235-->
By now this functions works only at Datasource expressions
<!--T:236-->
Syntax:
COUNT_DISTINCT(<expression>)
Example:
'''COUNT_DISTINCT("Product")''' - Returns number of unique (different) occurrences (lines) of products
==== IF ELSE function (If .... Otherwise ...) ==== <!--T:153-->
<!--T:219-->
* '''"@accumCol[column]"''' - Cumulative value from column to current row. Useful for calculating variable mean.
** Example: ''"@accumCol[column]"'' / ''"@row"''
* '''"@avg[column]"''' - Average column, similar to ''"@sum[column]"'' / ''"@count"''
* '''"@count"''' - Total number of rows that were returned for the component.
* '''"@prev[column]"''' - Row value before current row for this column
* '''"@row"''' - Current row number
* '''"@sum[column]"''' - Sum of the indicated column.
** Example: ''"@sum[Price]"'' - returns the sum of all rows in the ''Price'' column.
* '''"@avgtotalColumnValue[column]"''' - Average Value of total column, similar to ''"@sum[column]"'' / ''"@count"''* '''"@prev[column]"''' - Row value before current row for (if present), from this column.
* '''"@totalRowValue[column]"''' - Value of total row, (if present), from this column.
</translate>