This content has been marked as final. Show 2 replies
We are reading data from an excel file derived from SAP which contains customer sales data that is both positive (=sales) and negative (=returns). Our problem is that the minus sign comes AFTER the value, and somehow QV doesn't regognize this - thus giving us a net sales total for the customer that doesn't take returns into account.
I'm confessing to being somewhat new to QV still, so my humble question is - HELP! :-)