With this data and this summarize tool, the average net price of item A comes out as 3.00. How can I get it to be a weighted average (weighted by Qty) to give something like 3.82 instead?
@CullenJ two way for getting weighted average are attachedhope this help.
have you used the weighted average tool?
I haven't tried it yet - in my real use case, I am doing groupby on about 4 fields and then various actions (sum etc) on several other fields. I guess the best way would be to use this weighted average tool alongside the summarize and do a join to combine them?
This seems to work (combining summarize, weighted average tool, and join) - I suppose there's no way to do it with fewer nodes?
@CullenJ yes you can join; use the weighted average tool with grouping
