5 Replies Latest reply on Oct 10, 2019 3:03 AM by Ciara Brennan

    Weighted average.

    Oğuz HAN

      I would like to calculate the weighted averages of cities according to the mode of transport with the following calculation logic.

       

      Chico.....

       

      San Francisco

      Furniture          = 73,61% *

      Office Supplies = 77,50% *

      Teknology         = 72,73%

      Weighted Avg   = 41,49%     (73,61% * 77,50% * 72,73% = 41,49%)

       

      Seatle.......

       

      Could you help me please?