SummaryFunc

<< Click to Display Table of Contents >>

 

SummaryFunc

Enum Determines the type of function used for processing field values specified in the DataField property, as described on the next table. This property is only valid when the SummaryType property is different from 0 (zero).

Available options for the SummaryFunc property

Option

Description

0 - ddSFSum

Calculates the sum of all values inside the range of specified total values (default for group, page, or Report)

1 - ddSFAvg

Calculates the average of all values inside the range of specified total values (group, page, or Report)

2 - ddSFCount

Counts the number of values inside the range of specified total values (group, page, or Report)

3 - ddSFMin

Displays the lowest value (minimum value) inside the range of specified total values (group, page, or Report)

4 - ddSFMax

Displays the highest values (maximum value) inside the range of specified total values (group, page, or Report)

5 - ddSFVar

Calculates the variance of values inside the range of specified total values (group, page, or Report)

6 - ddSFVarP

Calculates the population variance of values inside the range of specified total values (group, page, or Report)

7 - ddSFStdDev

Calculates the standard deviation of values inside the range of specified total values (group, page, or Report)

8 - ddSFStdDevP

Calculates the population standard deviation of values inside the range of specified total values (group, page, or Report)

9 - ddSFDSum

Calculates the sum of all distinct values inside the range of specified total values (group, page, or Report)

10 - ddSFDAvg

Calculates the average based on distinct values inside the range of specified total values (group, page, or Report)

11 - ddSFDCount

Counts the number of distinct values inside the range of specified total values (group, page, or Report)

12 - ddSFDVar

Calculates the variance of distinct values inside the range of specified total values (group, page, or Report)

13 - ddSFDVarP

Calculates the population variance of distinct values inside the range of specified total values (group, page, or Report)

14 - ddSFDStdDev

Calculates the standard deviation of distinct values inside the range of specified total values (group, page, or Report)

15 - ddSFDStdDevP

Calculates the population standard deviation of distinct values inside the range of specified total values (group, page, or Report)

Was this page useful?