Hi, I am very new to Qlikview and am hoping to get some help on something I am stuck on. We had a QV developer build some reports for us already, and I am trying to expand on them. We have a report that shows Gold and Silver analysis of our product, with style listed and price that includes invoiced as well as return (credit) transactions. I want to get a total # of the units invoiced or credited, and this is the expression the developer added so far for a unit count:
This expression works in that it is totalling all of the items in the transaction, however for items on credit transactions I want it to count them as negative units. Would I need to add another expression below the one above to count credit transaction types as a negative, and how would the expression look? Any help would be greatly appreciated!