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

    Reading SAP data that is positive and negative

    BosseP999

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