Weighted Average Calculation Help

jcyc

Hi, 

I was trying to calculate weighted average for a number of companies that have $ values and Quantities. I tried using the weighted average tool but all it ever does is return the values instead of calculating a weight average for each line item. I've attached my workflow. Any help is appreciated.

weighted average test.yxmd

jdunkerley79

You have asked it to group by Company. This means it computes a weighted average for each unique company name.

Unticking that and then you get a single combined weighted average:

Hopefully, this is the answer you from the data. Otherwise could specify what output you expect.