I have a GI for drop shipped items that looks at the selling price on an SO and compares it with the cost on the associated PO. I have a calculated field for margin & margin %.
I would like to add this to a chart that tracks the weighted average margin % but the chart will simply give the average of the averages and is not weighted.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/e8900049-b862-464e-bd02-c7347f9b5223.png)
How can I make this a weighted average?