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

    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 ($)

       

       

      MARKETValue Contribution (%)Weighted Value ContributionValue Contribution ($)Weighted by VCIndustry Size
      Cars1.7%0.8%$50.048%$3,000.0
      Trucks4.0%0.3%$20.019%$500.0
      Boats1.1%0.3%$22.021%$2,000.0
      Planes1.2%0.2%$11.011%$900.0
      Bkes20.0%0.0%$1.01%$5.0
      28.0%1.6%$104.0100%$6,405.0

      Many Thanks,

      Brian

        • Another Weighted Average Question :)
          Stefan Wühl

          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.