How to Average a list of margin %?

[picnichouse]

Hi,

I have a pretty simple business report that shows Revenue, Cost of Goods, Gross Profit (Calculation: Revenue - Cost of Goods), and Profit Percent (Calculation: Gross Profit / Revenue).

The report is summarized by Customer, and I have Summary fields that total the first three fields and takes an average of the Profit Percet. The problem is, I don't really want an average profit percent -- I want the GrossProfitSUM / RevenueSUM. But when I write that calculation, it doesn't seem to work. I've had this problem before... what's the best way to handle this?

Thanks!

Andrew

[BobWeaver]

Use the GetSummary function to grab the GrossProfitSum and the RevenueSum like so:

GetSummary( GrossProfitSum;Customer)/GetSummary( RevenueSum;Customer)

Or, just create a weighted average summary field to do a weighted average of ProfitPercent weighted by RevenueSum, which I think should return the same number.