• Login

DataSoft Corporation

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