Mastering Business Analysis with Crystal Reports 9 (Wordware Applications Library)

Sum (fld)

Sum (fld, condFld)

Sum (fld, condFld, cond)

Sum (x)

Adds all the numbers that appear within a report.

fld is any valid database or formula field that can be evaluated by the function.

condFld is a field used to group the values in fld by.

cond is a String indicating the type of grouping for condFld. You only specify this argument when condFld is a Date, Time, DateTime, or Boolean field.

x is an array of values that can be evaluated by the function being used.

Average (fld)

Average (fld, condFld)

Average (fld, condFld, cond)

Average (x)

Enables you to average the values that appear in your report.

fld is any valid database or formula field that can be evaluated by the function.

condFld is a field used to group the values in fld by.

cond is a String indicating the type of grouping for condFld. You only specify this argument when condFld is a Date, Time, DateTime, or Boolean field.

x is an array of values that can be evaluated by the function being used.

StdDev (fld)

StdDev (fld, condFld)

StdDev (fld, condFld, cond)

StdDev (x)

Enables you to find the standard deviation of a set of values in your report.

fld is any valid database or formula field that can be evaluated by the function.

condFld is a field used to group the values in fld by.

cond is a String indicating the type of grouping for condFld. You only specify this argument when condFld is a Date, Time, DateTime, or Boolean field.

x is an array of values that can be evaluated by the function being used.

PopulationStdDev (fld)

PopulationStdDev (fld, condFld)

PopulationStdDev (fld, condFld, cond)

PopulationStdDev (x)

Enables you to find the population standard deviation of a set of values in your report.

fld is any valid database or formula field that can be evaluated by the function.

condFld is a field used to group the values in fld by.

cond is a String indicating the type of grouping for condFld. You only specify this argument when condFld is a Date, Time, DateTime, or Boolean field.

x is an array of values that can be evaluated by the function being used.

Variance (fld)

Variance (fld, condFld)

Variance (fld, condFld, cond)

Variance (x)

Enables you to find the variance of a set of values in your report.

fld is any valid database or formula field that can be evaluated by the function.

condFld is a field used to group the values in fld by.

cond is a String indicating the type of grouping for condFld. You only specify this argument when condFld is a Date, Time, DateTime, or Boolean field.

x is an array of values that can be evaluated by the function being used.

PopulationVariance (fld)

PopulationVariance (fld, condFld)

PopulationVariance (fld, condFld, cond)

PopulationVariance (x)

Enables you to find the population variance of a set of values in your report.

fld is any valid database or formula field that can be evaluated by the function.

condFld is a field used to group the values in fld by.

cond is a String indicating the type of grouping for condFld. You only specify this argument when condFld is a Date, Time, DateTime, or Boolean field.

x is an array of values that can be evaluated by the function being used.

Maximum (fld)

Maximum (fld, condFld)

Maximum (fld, condFld, cond)

Maximum (x)

Enables you to find the maximum value that appears in a set of values.

fld is any valid database or formula field that can be evaluated by the function.

condFld is a field used to group the values in fld by.

cond is a String indicating the type of grouping for condFld. You only specify this argument when condFld is a Date, Time, DateTime, or Boolean field.

x is an array of values that can be evaluated by the function being used.

Minimum (fld)

Minimum (fld, condFld)

Minimum (fld, condFld, cond)

Minimum (x)

Enables you to find the minimum value that appears in a set of values.

fld is any valid database or formula field that can be evaluated by the function.

condFld is a field used to group the values in fld by.

cond is a String indicating the type of grouping for condFld. You only specify this argument when condFld is a Date, Time, DateTime, or Boolean field.

x is an array of values that can be evaluated by the function being used.

Count (fld)

Count (fld, condFld)

Count (fld, condFld, cond)

Count (x)

Enables you to count the values that appear in your report (for a specified field).

fld is any valid database or formula field that can be evaluated by the function.

condFld is a field used to group the values in fld by.

cond is a String indicating the type of grouping for condFld. You only specify this argument when condFld is a Date, Time, DateTime, or Boolean field.

x is an array of values that can be evaluated by the function being used.

DistinctCount (fld)

DistinctCount (fld, condFld)

DistinctCount (fld, condFld, cond)

DistinctCount (x)

Enables you to get a distinct count of the values that appear in your report.

fld is any valid database or formula field that can be evaluated by the function.

condFld is a field used to group the values in fld by.

cond is a String indicating the type of grouping for condFld. You only specify this argument when condFld is a Date, Time, DateTime, or Boolean field.

x is an array of values that can be evaluated by the function being used.

Correlation (fld, fld)

Correlation (fld, fld, condFld)

Correlation (fld, fld, condFld, cond)

Enables you to calculate the correlation of the specified fields (that is, the degree to which the fields vary in the same manner).

fld is any numeric field.

condFld is a field used to group the values in fld by.

cond is a String indicating the type of grouping for condFld. You only specify this argument when condFld is a Date, Time, DateTime, or Boolean field.

Covariance (fld, fld)

Covariance (fld, fld, condFld)

Covariance (fld, fld, condFld, cond)

Covariance is the measure of the linear relation between paired variables (that is, the tendency of two fields to vary together). Fields are covariant when they vary according to a specific mathematical relationship. The circumference of a circle and the radius of a circle are covariant.

fld is any numeric field that can be evaluated by the function.

condFld is a field used to group the values in fld by.

cond is a String indicating the type of grouping for condFld. You only specify this argument when condFld is a Date, Time, DateTime, or Boolean field.

WeightedAverage (fld, fld)

WeightedAverage (fld, fld, condFld)

WeightedAverage (fld, fld, condFld, cond)

Enables you to calculate the weighted average of the specified fields. When you calculate a weighted average, you are actually calculating the average of one field and then using the values in another field to "weigh" the contribution of each value in the first field to the average. In a normal average, all the weights are equal to 1.

fld is any valid numeric database or formula field that can be evaluated by the function.

condFld is a field used to group the values in fld by.

cond is a String indicating the type of grouping for condFld. You only specify this argument when condFld is a Date, Time, DateTime, or Boolean field.

Median (fld)

Median (fld, condFld)

Median (fld, condFld, cond)

Calculates the median of the given numeric fields. The median is the middle value in a sequence of numeric values (or the average of the two middle values in an even-numbered sequence of values).

fld is any valid database or formula field that can be evaluated by the function.

condFld is a field used to group the values in fld by.

cond is a String indicating the type of grouping for condFld. You only specify this argument when condFld is a Date, Time, DateTime, or Boolean field.

PthPercentile (P, fld)

PthPercentile (P, fld, condFld)

PthPercentile (P, fld, condFld, cond)

Calculates the value for a specified percentile (P) in a Number or Currency field.

P is any integer from 0 to 100 (inclusive).

fld is any Number or Currency field that can be evaluated by the function.

condFld is a field used to group the values in fld by.

cond is a String indicating the type of grouping for condFld. You only specify this argument when condFld is a Date, Time, DateTime, or Boolean field.

NthSmallest (N, fld)

NthSmallest (N, fld, condFld)

NthSmallest (N, fld, condFld, cond)

Determines the Nth smallest value in a given field, either for the entire report or for each instance of the condFld group.

N is any integer from 1 to 100 (inclusive).

fld is any valid database or formula field that can be evaluated by the function.

condFld is a field used to group the values in fld by.

cond is a String indicating the type of grouping for condFld. You only specify this argument when condFld is a Date, Time, DateTime, or Boolean field.

Mode (fld)

Mode (fld, condFld)

Mode (fld, condFld, cond)

Identifies the most frequently occurring value.

fld is any valid database or formula field that can be evaluated by the function.

condFld is a field used to group the values in fld by.

cond is a String indicating the type of grouping for condFld. You only specify this argument when condFld is a Date, Time, DateTime, or Boolean field.

NthMostFrequent (N, fld)

NthMostFrequent (N, fld, condFld)

NthMostFrequent (N, fld, condFld, cond)

Determines the Nth most frequent value in a given field, either for the entire report or for each instance of the condFld group. If no values in the field appear more than once, the function will return the minimum value, by default.

N is any integer from 1 to 100 (inclusive).

fld is any valid database or formula field that can be evaluated by the function.

condFld is a field used to group the values in fld by.

cond is a String indicating the type of grouping for condFld. You only specify this argument when condFld is a Date, Time, DateTime, or Boolean field.

PercentOfSum (fld, condFld)

PercentOfSum (fld, condFld, cond)

PercentOfSum (fld, innerCondFld, outerCondFld)

PercentOfSum (fld, innerCondFld, innerCond, outerCondFld)

PercentOfSum (fld, innerCondFld, outerCondFld, outerCond)

PercentOfSum (fld, innerCondFld, innerCond, outerCondFld, outerCond)

Expresses the sum of the values of the field fld for the group determined by condFld as a percentage of the grand total sum.

fld is a Number or Currency field that can be evaluated by the function.

condFld is a field used to group the values in fld by.

cond is a String indicating the type of grouping for condFld. You only specify this argument when condFld is a Date, Time, DateTime, or Boolean field.

innerCondFld is a field used to group the values in fld by.

innerCond is a String indicating the type of grouping for innerCondFld. You only specify this argument when innerCondFld is a Date, Time, DateTime, or Boolean field.

outerCondFld is a field used to group the values in fld by.

outerCond is a String indicating the type of grouping for outerCondFld. You only specify this argument when outerCondFld is a Date, Time, DateTime, or Boolean field.

PercentOfAverage (fld, condFld)

PercentOfAverage (fld, condFld, cond)

PercentOfAverage (fld, innerCondFld, outerCondFld)

PercentOfAverage (fld, innerCondFld, innerCond, outerCondFld)

PercentOfAverage (fld, innerCondFld, outerCondFld, outerCond)

PercentOfAverage (fld, innerCondFld, innerCond, outerCondFld, outerCond)

Expresses the average of the values of the field fld for the group determined by condFld as a percentage of the average of all the values of fld.

fld is a Number or Currency field that can be evaluated by the function.

condFld is a field used to group the values in fld by.

cond is a String indicating the type of grouping for condFld. You only specify this argument when condFld is a Date, Time, DateTime, or Boolean field.

innerCondFld is a field used to group the values in fld by.

innerCond is a String indicating the type of grouping for innerCondFld. You only specify this argument when innerCondFld is a Date, Time, DateTime, or Boolean field.

outerCondFld is a field used to group the values in fld by.

outerCond is a String indicating the type of grouping for outerCondFld. You only specify this argument when outerCondFld is a Date, Time, DateTime, or Boolean field.

PercentOfMaximum (fld, condFld)

PercentOfMaximum (fld, condFld, cond)

PercentOfMaximum (fld, innerCondFld, outerCondFld)

PercentOfMaximum (fld, innerCondFld, innerCond, outerCondFld)

PercentOfMaximum (fld, innerCondFld, outerCondFld, outerCond)

PercentOfMaximum (fld, innerCondFld, innerCond, outerCondFld, outerCond)

Expresses the maximum of the values of the field fld for the group determined by condFld as a percentage of the maximum of all the values of fld.

fld is a Number or Currency field that can be evaluated by the function.

condFld is a field used to group the values in fld by.

cond is a String indicating the type of grouping for condFld. You only specify this argument when condFld is a Date, Time, DateTime, or Boolean field.

innerCondFld is a field used to group the values in fld by.

innerCond is a String indicating the type of grouping for innerCondFld. You only specify this argument when innerCondFld is a Date, Time, DateTime, or Boolean field.

outerCondFld is a field used to group the values in fld by.

outerCond is a String indicating the type of grouping for outerCondFld. You only specify this argument when outerCondFld is a Date, Time, DateTime, or Boolean field.

PercentOfMinimum (fld, condFld)

PercentOfMinimum (fld, condFld, cond)

PercentOfMinimum (fld, innerCondFld, outerCondFld)

PercentOfMinimum (fld, innerCondFld, innerCond, outerCondFld)

PercentOfMinimum (fld, innerCondFld, outerCondFld, outerCond)

PercentOfMinimum (fld, innerCondFld, innerCond, outerCondFld, outerCond)

Expresses the minimum of the values of the field fld for the group determined by condFld as a percentage of the minimum of all the values of fld.

fld is a Number or Currency field that can be evaluated by the function.

condFld is a field used to group the values in fld by.

cond is a String indicating the type of grouping for condFld. You only specify this argument when condFld is a Date, Time, DateTime, or Boolean field.

innerCondFld is a field used to group the values in fld by.

innerCond is a String indicating the type of grouping for innerCondFld. You only specify this argument when innerCondFld is a Date, Time, DateTime, or Boolean field.

outerCondFld is a field used to group the values in fld by.

outerCond is a String indicating the type of grouping for outerCondFld. You only specify this argument when outerCondFld is a Date, Time, DateTime, or Boolean field.

PercentOfCount (fld, condFld)

PercentOfCount (fld, condFld, cond)

PercentOfCount (fld, innerCondFld, outerCondFld)

PercentOfCount (fld, innerCondFld, innerCond, outerCondFld)

PercentOfCount (fld, innerCondFld, outerCondFld, outerCond)

PercentOfCount (fld, innerCondFld, innerCond, outerCondFld, outerCond)

Expresses the count of the values of the field fld for the group determined by condFld as a percentage of the count of all the values of fld.

fld is a Number, Currency, String, Boolean, Date, Time, or DateTime field that can be evaluated by the function.

condFld is a field used to group the values in fld by.

cond is a String indicating the type of grouping for condFld. You only specify this argument when condFld is a Date, Time, DateTime, or Boolean field.

innerCondFld is a field used to group the values in fld by.

innerCond is a String indicating the type of grouping for innerCondFld. You only specify this argument when innerCondFld is a Date, Time, DateTime, or Boolean field.

outerCondFld is a field used to group the values in fld by.

outerCond is a String indicating the type of grouping for outerCondFld. You only specify this argument when outerCondFld is a Date, Time, DateTime, or Boolean field.

PercentOfDistinctCount (fld, condFld)

PercentOfDistinctCount (fld, condFld, cond)

PercentOfDistinctCount (fld, innerCondFld, outerCondFld)

PercentOfDistinctCount (fld, innerCondFld, innerCond, outerCondFld)

PercentOfDistinctCount (fld, innerCondFld, outerCondFld, outerCond)

PercentOfDistinctCount (fld, innerCondFld, innerCond, outerCond4Fld, outerCond)

Expresses the distinct count of the values of the field fld for the group determined by condFld as a percentage of the distinct count of all the values of fld.

fld is a Number, Currency, String, Boolean, Date, Time, or DateTime field that can be evaluated by the function.

condFld is a field used to group the values in fld by.

cond is a String indicating the type of grouping for condFld. You only specify this argument when condFld is a Date, Time, DateTime, or Boolean field.

innerCondFld is a field used to group the values in fld by.

innerCond is a String indicating the type of grouping for innerCondFld. You only specify this argument when innerCondFld is a Date, Time, DateTime, or Boolean field.

outerCondFld is a field used to group the values in fld by.

outerCond is a String indicating the type of grouping for outerCondFld. You only specify this argument when outerCondFld is a Date, Time, DateTime, or Boolean field.