Another Weighted Average Question :)

[#1]

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

[swuehl]

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.