topic Reading SAP data that is positive and negative in QlikView https://community.qlik.com/t5/QlikView/Reading-SAP-data-that-is-positive-and-negative/m-p/271572#M1202619 <HTML><HEAD></HEAD><BODY><P>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.</P><P>I'm confessing to being somewhat new to QV still, so my humble question is - HELP! <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P></P></BODY></HTML> Tue, 17 Aug 2010 12:05:38 GMT 2010-08-17T12:05:38Z Reading SAP data that is positive and negative https://community.qlik.com/t5/QlikView/Reading-SAP-data-that-is-positive-and-negative/m-p/271572#M1202619 <HTML><HEAD></HEAD><BODY><P>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.</P><P>I'm confessing to being somewhat new to QV still, so my humble question is - HELP! <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P></P></BODY></HTML> Tue, 17 Aug 2010 12:05:38 GMT https://community.qlik.com/t5/QlikView/Reading-SAP-data-that-is-positive-and-negative/m-p/271572#M1202619 2010-08-17T12:05:38Z Reading SAP data that is positive and negative https://community.qlik.com/t5/QlikView/Reading-SAP-data-that-is-positive-and-negative/m-p/271573#M1202620 <HTML><HEAD></HEAD><BODY><P>num#('12-') appears to return the number -12</P></BODY></HTML> Tue, 17 Aug 2010 22:17:31 GMT https://community.qlik.com/t5/QlikView/Reading-SAP-data-that-is-positive-and-negative/m-p/271573#M1202620 johnw 2010-08-17T22:17:31Z Reading SAP data that is positive and negative https://community.qlik.com/t5/QlikView/Reading-SAP-data-that-is-positive-and-negative/m-p/271574#M1202621 <HTML><HEAD></HEAD><BODY><P>Thanks for your suggestion John!</P><P>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.</P></BODY></HTML> Wed, 18 Aug 2010 07:01:42 GMT https://community.qlik.com/t5/QlikView/Reading-SAP-data-that-is-positive-and-negative/m-p/271574#M1202621 2010-08-18T07:01:42Z