Jump to content

How to Average a list of margin %?


This topic is 5644 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 5644 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.