Weighted Average

[n1ef5ng1]

I need to find out the weighted average for one of my columns in KPI, each KPI value need a certain formula to derive the result.

Is it advisable to list out the formula on the expreesion list?

For weighted average,

below are my data example

Type: A Box: 2 Amount : 5

Type: B Box: 3 Amount 6

Type: C Box: 5 Amount : 7

Type: D Box: 6 Amount 8

in this above data, the total box will be 2 + 3+5+6 = 16

The formula to dervice is

(BOX/ TOTAL BOX) * Amount = Result 1

Then sum all the result from the above formula to get the weighted average, how do i do it with this complxity. thank you