Sage 100

Crystal Reports need help with gross profit % calculation for group (Crystal 2011, v2017) Client wants to see group summaries only (no details) to determine profitability by warehouse and by vendor. Group 1 = Vendor, Group 2 = Warehouse. Selection criteria: invoice date range and warehouse selection (a single whse or all whses). Columns client wants for summaries: Revenue (product only)/COGS/GP% Where I'm stuck right now is on the group GP% calculations. Here's where I am: COGS formula: {AR_InvoiceHistoryDetail.QuantityShipped} * {AR_InvoiceHistoryDetail.UnitCost} GP% formula for detail lines: (({AR_InvoiceHistoryDetail.ExtensionAmt} - ({AR_InvoiceHistoryDetail.QuantityShipped} * {AR_InvoiceHistoryDetail.UnitCost}))/{AR_InvoiceHistoryDetail.ExtensionAmt}) * 100 Good so far. GPWhse% formula: I thought this would work, but it's not. Using summaries of the Revenue & COGS summaries. (Sum ({AR_InvoiceHistoryDetail.ExtensionAmt}, {AR_InvoiceHistoryDetail.WarehouseCode}) - (Sum ({AR_InvoiceHistoryDetail.QuantityShipped}, {AR_InvoiceHistoryDetail.WarehouseCode}) * Sum ({@COGS}, {AR_InvoiceHistoryDetail.WarehouseCode})) / Sum ({AR_InvoiceHistoryDetail.ExtensionAmt}, {AR_InvoiceHistoryDetail.WarehouseCode})) * 100 Banging head against a wall. Please help. Or is this the wrong approach?

You can't use the sum of the quantity shipped x cogs. Just use the sum of the sales price extension - sum of the cogs divided by the sum of the sales price extension x 100.

Thanks @DougHiggs , I was overthinking it.