0) THEN ([AR SALED Item Total] - ([AR SALED Item Cost] * [AR SALED Qty])) / [AR SALED Item Total] * 100 ELSE 0 END AS MarginPerc FROM [SYS Company], ([AR Customer] INNER JOIN [AR Sales] ON [AR Customer].[AR CUST Customer ID] = [AR Sales].[AR SALE Customer ID]) INNER JOIN [AR Sales Detail] ON [AR Sales].[AR SALE Document #] = [AR Sales Detail].[AR SALED Document #] WHERE [AR SALE Document Type] = 'Invoice'"!>

 

Invoice Margin by Customer
Customer ID Customer Name
  Item ID Description Qty Sales Price Cost Margin Margin (%)
 
  %