2 Replies Latest reply: Aug 18, 2010 3:01 AM by BosseP999 RSS

    Reading SAP data that is positive and negative


      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! :-)