Report Number Formatting Oddity

I added two columns (Cost & Profit) to the HQ Report 'Detailed Sales Report with Customer' after downloading from CustomerSource.

The Total Sales (a 'factory' column) displays negative numbers in parenthesis. The Profit column (one I added) does the same. The Cost colum (also one I added) puts a minus sign in front of the dollar sign.

What gives?

FYI - Here's the code I added: Begin Column FieldName = "Cost" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Cost" VBDataType = vbCurrency Formula = "TransactionEntry.Cost * TransactionEntry.Quantity" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 855 GroupMethod = groupmethodSum ColFormat = "" End Column

Begin Column FieldName = "Profit" DrillDownFieldName = "" DrillDownReportName = "" Title = "Profit" VBDataType = vbCurrency Formula = "(TransactionEntry.Price * TransactionEntry.Quantity) - (TransactionEntry.Cost * TransactionEntry.Quantity)" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 855 GroupMethod = groupmethodSum ColFormat = "" End Column

Any advice you might have would be appreciated,

Tom

Reply to
Terrible Tom
Loading thread data ...

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.