UsageGuide

Aggregates Aggregate functions are performed across a collection of rows. Aggregate extensions show up in the Aggregate Builder and behave like the built-in BIRT Aggregates (e.g. Count, Sum...) Custom aggregates support all of the grouping and filtering options that the standard aggregates support. The birt-aggregations-lib project adds a set of aggregations to use in place of the built-in aggregations to avoid the tiny errors that can be produced by floating-point calculations.

Built-In Aggregate Corresponding Decimal Aggregate AVE Decimal Average FIRST Decimal First LAST Decimal Last MAX Decimal Max MEDIAN Decimal Median MIN Decimal Min MODE Decimal Mode MOVINGAVE Decimal Moving Ave NPV Decimal NPV PERCENTILE Decimal Percentile PERCENTSUM Decimal Percent Sum QUARTILE Decimal Quartile RANGE Decimal Range RUNNINGNPV Decimal Running NPV RUNNINGSUM Decimal Running Sum STDDEV Decimal StdDev SUM Decimal Sum VARIANCE Decimal Variance WEIGHTEDAVE Decimal Weighted Ave