Anyone know how I can convert the 2 sum's into a formula giving percentage of total? Context - post the formula, I want to do weighted average so 75% of Quantity X 25% of Amount but for that I need to change the percentage of total into a formula I think

Should be able to do a formula numeric field. Something like SUM({quantity}) / SUM({fxamount}).