Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.