If anyone was ever wanting to put the gross profit margin in an Item Price List report, I created this Column list that you can use; just thought it might be helpful to someone. It uses an SQL query in the formula and it produces a GPM of 0 when the price is 0, even though that's not really accurate. You may want to change it to just produce a null value. Just copy your report file from Item price list and add this wherever you want it under the Columns header, then name it Custom - (Your Report Name).qrp
Begin Column FieldName = "Item.GPM" DrillDownFieldName = "" DrillDownReportName = "" Title = "GPM" VBDataType = vbString Formula = "CASE WHEN Item.Price > 0 THEN (Item.Price-Item.Cost)/ (Item.Price)*100 ELSE 0 END" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 765 GroupMethod = groupmethodAverage ColFormat = "" End Column