I have a grid view with a simple formula field: GP% = profit/price.

Works at a line item level but for the Column Total, I need the formula to continue to calculate total profit / total price. Unfortunately all I can do now is e.g. SUM or AVG, which of course is an incorrect result.