https://community.qlik.com/t5/Data-Quality/Dealing-with-differences-in-positive-and-negative-quantity-and/m-p/2515426#M4164 <P>This isn't really a question anyone here can answer for you. You'll have to pose this question to the business users involved in the process.</P> Wed, 23 Apr 2025 10:28:42 GMT Or 2025-04-23T10:28:42Z https://community.qlik.com/t5/Data-Quality/Dealing-with-differences-in-positive-and-negative-quantity-and/m-p/2515416#M4163 <P>I'm working with a table that has these 4 conditions:</P> <P>Positive quantity &amp; Positive Sale - regular Sale</P> <P>Negative quantity &amp; Negative Sale - as it seems it's a Return</P> <P>Positive quantity &amp; 0 in Sale - as it seems it's a gift/promo item</P> <P>Positive quantity &amp; Negative Sale - can be an error or refund</P> <P>How can I deal with these different types of sale to calculate margin and margin%? Is it better to convert all the errors/refunds to negative quantities?</P> Wed, 23 Apr 2025 09:28:07 GMT https://community.qlik.com/t5/Data-Quality/Dealing-with-differences-in-positive-and-negative-quantity-and/m-p/2515416#M4163 marjorie18 2025-04-23T09:28:07Z https://community.qlik.com/t5/Data-Quality/Dealing-with-differences-in-positive-and-negative-quantity-and/m-p/2515426#M4164 <P>This isn't really a question anyone here can answer for you. You'll have to pose this question to the business users involved in the process.</P> Wed, 23 Apr 2025 10:28:42 GMT https://community.qlik.com/t5/Data-Quality/Dealing-with-differences-in-positive-and-negative-quantity-and/m-p/2515426#M4164 Or 2025-04-23T10:28:42Z