# Functions for Summary Expression Editor

#### Use the following functions when calculating summaries across a report and its groups:

 Function Description Example sumAvg(Expression) Calculates the average of all the values within the specified summary region (group, page or report). sumAvg([UnitPrice]) sumCount(Expression) Counts the number of values within the specified summary region (group, page or report). In a simple scenario, you may not pass a parameter. When using this function in a master-detail report's master band and passing a detail's field as a parameter, it counts the number of records within the detail's band. sumCount([UnitPrice]) sumDAvg(Expression) Calculates the average of all the distinct values within the specified summary region (group, page or report). sumDAvg([UnitPrice]) sumDCount(Expression) Counts the number of distinct values within the specified summary region (group, page or report). In a simple scenario, you may not pass a parameter. sumDCount([UnitPrice]) sumDStdDev(Expression) Calculates the standard deviation of all the distinct values within the specified summary region (group, page or report). sumDStdDev([UnitPrice]) sumDStdDevP(Expression) Calculates the standard population deviation of all the distinct values within the specified summary region (group, page or report). sumDStdDevP([UnitPrice]) sumDSum(Expression) Calculates the total of all the distinct values within the specified summary region (group, page or report). sumDSum([UnitPrice]) sumDVar(Expression) Calculates the amount of variance for all the distinct values within the specified summary region (group, page or report). sumDVar([UnitPrice]) sumDVarP(Expression) Calculates the population variance of all the distinct values within the specified summary region (group, page or report). sumDVarP([UnitPrice]) sumMax(Expression) Calculates the maximum of all the values within the specified summary region (group, page or report). sumMax([UnitPrice]) sumMedian(Expression) Finds the middle number within a sequence. Note that if the total number of elements is odd, this function returns the value of the middle number in a sequence. If the total number of elements is even, this function returns the arithmetical mean of the two middle numbers. sumMedian([UnitPrice]) sumMin(Expression) Calculates the minimum of all the values within the specified summary region (group, page or report). sumMin([UnitPrice]) sumPercentage(Expression) Calculates the percent ratio of the current data row's value to the total of all the values within the specified summary region (group, page or report). sumPercentage([UnitPrice]) sumRecordNumber(Expression) Returns the current record number in the specified summary region (group, page or report). This means for instance, if the summary is calculated for a group, then the record number is calculated only within that group, and is reset every time a new group is started. In a simple scenario, you may not pass a parameter. sumRecordNumber() sumRunningSum(Expression) Summarizes all the values, which were printed before the current data row, with the current data row's value. sumRunningSum([UnitPrice]) sumStdDev(Expression) Calculates the standard deviation of all the values within the specified summary region (group, page or report). sumStdDev([UnitPrice]) sumStdDevP(Expression) Calculates the standard population deviation of all the values within the specified summary region (group, page or report). sumStdDevP([UnitPrice]) sumSum(Expression) Calculates the total of all the values within the specified summary region (group, page or report). sumSum([UnitsInStock]) sumVar(Expression) Calculates the amount of variance for all the values within the specified summary region (group, page or report). sumVar([UnitPrice]) sumVarP(Expression) Calculates the population variance of all the values within the specified summary region (group, page or report). sumVarP([UnitPrice])
Thursday, 27 December 2018 Posted in Expressions Constants, Operators, and Functions