dimanche 29 mars 2015

Exclude from result if Sum = 0

How to exclude records from the result if (+)LotQty has the same with (-)LotQty but different Transtype.


Example : from this



Docentry Transtype LotQty
4594 67 250.000000
4643 60 -250.000000
9253 67 100.000000
16822 60 -200.000000


to this



Docentry Transtype LotQty
9253 67 100.000000
16822 60 -200.000000**

Aucun commentaire:

Enregistrer un commentaire