3 Replies Latest reply on Apr 4, 2016 7:49 AM by Mahfooj Khan

    Weighted Average (row-based)

    malou.puyod.0

      Is it possible to create a weighted average for 2 or more columns while the other columns are in Sum?

       

      Screen Shot 2016-04-02 at 3.41.39 AM.png

       

      I need to get the Sum and Weighted Average per Region (Total row):

      Order Volume --> Sum

       

      Interval 1 and Interval 2 =

             (   ( for Vendor ABC01:  Order Volume * Interval 1 ) + ( for Vendor DEF05:  Order Volume * Interval 1 ) + ( for Vendor GHI04:  Order Volume * Interval 1 )      )  /  ( SUM(Order Volume))

      eg.

          (  (9 * 33) + (10 * 15) + (9*12)   )  / 28   = 19.82   (Weighted Average for Interval 1)

               

      The output should look like this:

       

      Screen Shot 2016-04-02 at 3.56.48 AM.png