Welcome to LightSwitch Desktop Edition > OLAP for LightSwitch Overview > OLAP for LightSwitch Task-Based Help > Calculating Weighted Averages and Sums |
There may be cases where it is necessary to find the weighted average or sum of your data. In a weighted average or sum, some data points contribute more to the subtotal than others.
Suppose you have a bound list of products and you want to find the average price for the group of products, taking into account the quantity of each product purchased. You can weight the price average by the number of units purchased. This can be done at run time using the Field Settings dialog box.