## Functions to duplicate group fields

Use these functions whenever you want to duplicate a group field in a formula.

Note: In order to use these functions, you must have already entered a group field in your report with identical parameters to those you plan to reproduce in the formula. For example, the same field, same sort-and-group-by field, same date/Boolean condition (if applicable), or same action (average, count).

### Sort and group by field = character, number, or dollar value

Average (fld, condFld)

See Average (fld), Average (fld, condFld), Average (fld, condFld, cond), Average (x)

Count (fld, condFld)

See Count (fld), Count (fld, condFld), Count (fld, condFld, cond), Count (x)

DistinctCount (fld, condFld)

See DistinctCount (fld), DistinctCount (fld, condFld), DistinctCount (fld, condFld, cond), DistinctCount (x)

Maximum (fld, condFld)

See Maximum (fld), Maximum (fld, condFld), Maximum (fld, condFld, cond), Maximum (x)

Minimum (fld, condFld)

See Minimum (fld), Minimum (fld, condFld), Minimum (fld, condFld, cond), Minimum (x)

PopulationStdDev (fld, condFld)

See PopulationStdDev (fld), PopulationStdDev (fld, condFld), PopulationStdDev (fld, condFld, cond), PopulationStdDev (x)

PopulationVariance (fld, condFld)

See PopulationVariance (fld), PopulationVariance (fld, condFld), PopulationVariance (fld, condFld, cond), PopulationVariance (x)

StdDev (fld, condFld)

See StdDev (fld), StdDev (fld, condFld), StdDev (fld, condFld, cond), StdDev (x)

Sum (fld, condFld)

See Sum (fld), Sum (fld, fld), Sum (fld, condFld), Sum (fld, condFld, cond), Sum (x)

Variance (fld, condFld)

See Variance (fld), Variance (fld, condFld), Variance (fld, condFld, cond), Variance (x)

### Sort and group by field = date or Boolean

Average (fld, condFld, cond)

See Average (fld), Average (fld, condFld), Average (fld, condFld, cond), Average (x)

Count (fld, condFld, cond)

See Count (fld), Count (fld, condFld), Count (fld, condFld, cond), Count (x)

DistinctCount (fld, condFld, cond)

See DistinctCount (fld), DistinctCount (fld, condFld), DistinctCount (fld, condFld, cond), DistinctCount (x)

Maximum (fld, condFld, cond)

See Maximum (fld), Maximum (fld, condFld), Maximum (fld, condFld, cond), Maximum (x)

Minimum (fld, condFld, cond)

See Minimum (fld), Minimum (fld, condFld), Minimum (fld, condFld, cond), Minimum (x)

PopulationStdDev (fld, condFld, cond)

See PopulationStdDev (fld), PopulationStdDev (fld, condFld), PopulationStdDev (fld, condFld, cond), PopulationStdDev (x)

PopulationVariance (fld, condFld, cond)

See PopulationVariance (fld), PopulationVariance (fld, condFld), PopulationVariance (fld, condFld, cond), PopulationVariance (x)

StdDev (fld, condFld, cond)

See StdDev (fld), StdDev (fld, condFld), StdDev (fld, condFld, cond), StdDev (x)

Sum (fld, condFld, cond)

See Sum (fld), Sum (fld, fld), Sum (fld, condFld), Sum (fld, condFld, cond), Sum (x)

Variance (fld, condFld, cond)

See Variance (fld), Variance (fld, condFld), Variance (fld, condFld, cond), Variance (x)

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com