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.
Calculate Average For: Select the numeric column that contains the data to return the weighted average.
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.
Output Column Name: Enter the desired output column name for the calculated weighted average.
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.