Difference between revisions of "Translations:Expressions/219/en"
(Importing a new version from external source) |
(Importing a new version from external source) |
||
Line 5: | Line 5: | ||
* '''"@avg[column]"''' - Average column, similar to ''"@sum[column]"'' / ''"@count"'' | * '''"@avg[column]"''' - Average column, similar to ''"@sum[column]"'' / ''"@count"'' | ||
* '''"@prev[column]"''' - Row value before current row for this column | * '''"@prev[column]"''' - Row value before current row for this column | ||
+ | * '''"@totalRowValue[column]"''' - Value of total row, (if present), from this column. | ||
* '''"@accumCol[column]"''' - Cumulative value from column to current row. Useful for calculating variable mean. | * '''"@accumCol[column]"''' - Cumulative value from column to current row. Useful for calculating variable mean. | ||
** Example: ''"@accumCol[column]"'' / ''"@row"'' | ** Example: ''"@accumCol[column]"'' / ''"@row"'' |
Latest revision as of 15:18, 7 July 2021
- "@count" - Total number of rows that were returned for the component.
- "@row" - Current row number
- "@sum[column]" - Sum of the indicated column.
- Example: "@sum[Price]" - returns the sum of all rows in the Price column.
- "@avg[column]" - Average column, similar to "@sum[column]" / "@count"
- "@prev[column]" - Row value before current row for this column
- "@totalRowValue[column]" - Value of total row, (if present), from this column.
- "@accumCol[column]" - Cumulative value from column to current row. Useful for calculating variable mean.
- Example: "@accumCol[column]" / "@row"