
Help with Gross Profit %
Karl Pover Nov 11, 2010 1:53 PM (in response to Chris Hopkins )The following expression doesn't work?
sum({$<LineType = {V}>} total <[Cust Name],[Product Code],[Prod Desc],EAN,Size,PriceOverride> ItemCost)
Regards.

Help with Gross Profit %
Chris Hopkins Nov 12, 2010 5:07 AM (in response to Karl Pover )Hi, thanks for your reply again, No that expression doesn't work....
Can anyone help?

Help with Gross Profit %
John Witherspoon Nov 12, 2010 5:18 PM (in response to Chris Hopkins )If you know the right expressions for sales and for cost, and you know how to calculate gross profit from sales and cost, where is the confusion? The only thing I'd point out is that (AB)/A = 1B/A. So gross profit margin is also 1cost/sales, which will save you having to calculate the sales twice. So assuming you have the right expressions for sales and for cost:
1sum(aggr(sum({$<LineType = {V}>} total <EAN> ItemCost ),[Cust Name],[Product Code],[Prod Desc],EAN,Size,PriceOverride))
/sum(aggr(sum({$<LineType = {V}>} total <EAN> SalesValue),[Cust Name],[Product Code],[Prod Desc],EAN,Size,PriceOverride))

