Skip to main content

Weighted Average Tool

Use Weighted Average to calculate the weighted average of an incoming data column.

A weighted average is similar to a common average, but instead of all rows contributing equally to the average, the idea of weight means some rows contribute more than others.

Tip

This tool has a One Tool Example. Visit Access Sample Workflows to learn how to access this and many other examples directly in Designer Cloud.

Configure the Tool

  1. Calculate Average For: Select the numeric column that contains the data to return the weighted average.

  2. Use Weight From: Select the numeric column that contains the weight to calculate the weighted average. When all rows have the same weight, the returned value is a common average.

  3. Output Column Name: Enter the desired output column name for the calculated weighted average.

  4. Columns to Group By (Optional): This is an optional setting. You can elect to specify a grouping column and the weighted average will be calculated for each group of values in the data stream.

In this section: