Dealing with differences in positive and negative quantity and price in Sales

[marjorie18]

I'm working with a table that has these 4 conditions:

Positive quantity & Positive Sale - regular Sale

Negative quantity & Negative Sale - as it seems it's a Return

Positive quantity & 0 in Sale - as it seems it's a gift/promo item

Positive quantity & Negative Sale - can be an error or refund

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?

[Or · Accepted solution]

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.