Skip to content
Steve Schafer edited this page Mar 25, 2024 · 2 revisions

Welcome to the birt-aggregations-lib wiki!

Business Intelligence and Reporting Tools (BIRT)is a top level Eclipse project. As an Eclipse project, BIRT is built for extendability. Developers can customize BIRT to support custom controls and behavior through BIRT extension points. Extension points allow complex custom operations to be integrated right into the BIRT UI and scripting language.

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


All of the provided aggregations have been tested for compatibility with BIRT 4.14 and is compatible with BIRT 2.5.1 or later.

Innovent Solutions, Inc. is a consulting firm and a member of the BIRT project team since 2004. The software in this project has been donated back to the BIRT community by Innovent under an Eclipse Public License 2.0. We welcome you to use, critique, and contribute to this component library.

To get started see the Usage Guide