Skip to main content
BuyLog In
.NET Reporting Tools
Search in…
Docs > Detailed Guide to DevExpress Reporting > Shape Report Data > Shape Data (Expression Bindings) > Calculate a Weighted Average
A newer version of this page is available. .
All docs
V19.2
Reporting
Product Information
Get Started with DevExpress Reporting
Create Popular Reports
Detailed Guide to DevExpress Reporting
Introduction to Banded Reports
Provide Data to Reports
Use Report Controls
Shape Report Data
Filter Data
Group and Sort
Shape Data (Expression Bindings)
Format Data
Conditionally Change a Control's Appearance
Conditionally Change a Label's Text
Conditionally Filter Report Data
Conditionally Suppress Controls
Limit the Number of Records per Page
Conditionally Change a Band's Visibility
Calculate a Summary
Calculate an Advanced Summary
Calculate a Weighted Average
Display Row Numbers in a Report, Group or Page
Count the Number of Records in a Report or Group
Count the Number of Groups in a Report
Shape Data (Legacy Data Bindings)
Use Calculated Fields
Use Report Parameters
Arrange Dynamic Report Contents
Customize Appearance
Add Navigation
Provide Interactivity
Add Extra Information
Merge Reports
Use Expressions
Store and Distribute Reports
Reporting API
Visual Studio Report Designer
Create End-User Reporting Applications
Reporting in .NET Core 3 (CTP)
API Reference
ASP.NET Core API Reference
Client API Reference
Client API Reference (WebForms & MVC)
Download CHM

Calculate a Weighted Average

  • 2 minutes to read

Note

Set the UserDesignerOptions.DataBindingMode property to DataBindingMode.Expressions or DataBindingMode.ExpressionsAdvanced to use this approach.

Refer to Calculate a Weighted Average (Legacy Approach) for information on the legacy approach to weighted average calculations.

See Data Binding Modes for the available bind modes.

xtrareports-weighted-average

Follow the steps below to calculate a weighted average for Unit Price (weight values are taken from the Units in Stock field):

  1. Open an existing reporting application or create a new one from scratch.
  2. Bind a report to the sample Northwind database’s Products table (the nwind.mdb file is included in the XtraReports installation).

  3. Use the Group and Sort Panel to group the report data by the CategoryName data field and construct a layout like the following:

    report-multiple-summaries-initial-layout

  4. Add the Group Footer band to the report and drop a XRLabel control on this band to display the summary result. Click the label’s smart tag, then click the Summary field’s ellipsis button.

    xtrareports-label-smarttag

  5. In the invoked Summary Editor window:

    • Set the Summary Running property to Group.
    • Set the Summary Function property to Weighed average.
    • Set the Argument Expression property to [UnitPrice], and the Weight property to [UnitsInStock]

    report-multiple-summaries-running-property

  6. You can also use the control’s Format String property to format the summary value. For instance, set this property to Weighted Average Price: {0:c2}.