|
Posted by Wesley Sanders on July 7, 2008, 10:56 pm
Please log in for more thread options
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
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap