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

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.