zerion reports
What are summary functions in Tabular View?
The Zerion Reports Tabular View enables you to apply summary functions to the columns in the tabular view. You can apply one or more summary functions to a column. When you apply a summary function over a column, a summary row for each group (block and section) and a grand summary row for the view will be displayed.
How do apply summary functions?
To apply summary functions to your Zerion Reports Summary View, please follow the instructions below.
step 1
With your Tabular View loaded, select the column to which you want to apply the summary function.
step 2
From the Summary drop-down menu, select your function.
step 3
Click OK.
Listed below are the sets of summary functions supported by Zerion Reports for a tabular view and their functionalities.
Numeric and Currency Data Type | |
Function | Description |
Sum |
Returns the sum of all the values in the column. If the columns are grouped, summation will be applied at the group level. |
Average | Returns arithmetic mean of all the values in the column. In case grouping has been applied, it will return the average value at the group level. |
Count Records | Returns a count of the number of records in the column. If grouping is applied, it then provides the total number of records at the group level. |
Min | Returns minimum value in the column. If the columns are grouped, then the minimum value will be applied at the group level. |
Max | Returns maximum value in the column. If the columns are grouped, then the maximum value will be applied at group level. |
Standard Deviation | Returns the standard deviation of the column. If the columns are grouped, then it will then display the standard deviation at the group level. |
Variance | Returns the variance of the column. If the columns are grouped, then the function will be applied at the group level. |
String Data Type | |
Count Records |
Returns the count of the number of records in the column. If grouping is applied, it then provides the total number of records at the group level. |
Comments
0 comments
Please sign in to leave a comment.