Weighted average with summary tool?

[CullenJ]

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?

 

 

[aatalai]

have you used the weighted average tool?

[CullenJ]

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?

[CullenJ]

This seems to work (combining summarize, weighted average tool, and join) - I suppose there's no way to do it with fewer nodes?

[aatalai]

@CullenJ yes you can join; use the weighted average tool with grouping

[Raj · Accepted solution]

@CullenJ 
two way for getting weighted average are attached
hope this help.

[CullenJ]

Thanks Raj, if I want to get weighted average of multiple fields, is that possible using the weighted average tool? If not, it seems like doing your way with the formulas and the summarize is better?