Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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! 🙂
num#('12-') appears to return the number -12
Thanks for your suggestion John!
We managed to get around the problem my manually applying a formula in Excel, which moved the sign from the end to the front, but I suspect your solution would be a more automated one.