Weighted average - Sales vs. Budget

[DanaL]

Hi People,

Which is the best way to calculate the weighted average percentage of the following?

Thanks in advance!

[Kushal_Chawda]

@DanaL  for calculation of weighted average you need to assign the weight for each category. What are the weights for each region?

[DanaL]

Hi @Kushal_Chawda,

Does it mean that I have to calculate it beforehand in the script or I can do it in he chart?

What would be the final expression, assuming sales weight is X, and budget weight is Y?

Thanks!

[Fischer54]

The average is the sum of all individual observations divided by the number of observations. In contrast, the weighted average is observation multiplied by the weight and added to find a solution.

myccpay

[DanaL]

Hi @Fischer54 ,

Per table row - the calculation is correct.

So I only need it for the total line.

Is there any way to calculate the weight in the chart, or should it be done in the script?

Thanks!