1 Reply Latest reply: Feb 7, 2012 2:04 PM by Stefan Wühl

Another Weighted Average Question :)

Team - i need to create an expression that calculates the Weighted Value Contribution (column 2). I'm stuck!

Here are my expressions

1) Value Contribution (%) = Value Contribution (\$) / Industry Size

2) Weighted Value Contribution = TOTAL of Weighted Value Contribution * Weighted by VC

3) Weighted by VC = Value Contribution (\$) / TOTAL Value Contribution (\$)

 MARKET Value Contribution (%) Weighted Value Contribution Value Contribution (\$) Weighted by VC Industry Size Cars 1.7% 0.8% \$50.0 48% \$3,000.0 Trucks 4.0% 0.3% \$20.0 19% \$500.0 Boats 1.1% 0.3% \$22.0 21% \$2,000.0 Planes 1.2% 0.2% \$11.0 11% \$900.0 Bkes 20.0% 0.0% \$1.0 1% \$5.0 28.0% 1.6% \$104.0 100% \$6,405.0

Many Thanks,

Brian

• Another Weighted Average Question :)

Maybe it's a little to late for me this evening:

Weighted Value Contribution = TOTAL of Weighted Value Contribution * Weighted by VC

Here you define a value by referencing the value, isn't this a logical loop?

Or maybe TOTAL of Weighted Value Contribution is a constant, like 100% or 1, but then it will just be

Weighted Value Contribution = Weighted by VC * const.

and you would need to define the constant, but I don't think that's what you want.