Can reports show a percentage?

- J
- JD Byers
  
  Contact options for registered users
posted
15 years ago

Thu, Oct 23, 2008 3:46 PM

Is there a way to show a percentage in the SO reports? I would like a report to show the profit as a percentage of the sales on a few reports.

Thanks, JD Byers

Loading thread data ...

- L
- Luminox
  
  Contact options for registered users
Vote on answer
posted
15 years ago

Fri, Oct 24, 2008 12:56 PM

Sure ... have several reports that I modified to show this. See below.

Begin Column FieldName = "ProfitMargin" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Margin" VBDataType = vbDouble Formula = "CASE WHEN ViewStoreSales.TotalSales > 0 THEN (VIEWStoreSales.TotalSales-VIEWStoreQty.TotalCost) / ViewStoreSales.TotalSales END" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 750 GroupMethod = groupmethodAverage ColFormat = "%.##" ColAlignment = flexAlignRightCenter End Column

"JD Byers" wrote:

- C
- convoluted
  
  Contact options for registered users
Vote on answer
posted
15 years ago

Tue, Oct 28, 2008 2:17 PM

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.