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