Debit/credit Qty group

[Guest_imported]

In my report, i have grouped by Item No that have both debit qty and credit qty (under same field - QTY).<br>How can i separate the quantity to 2 columns for the same item no ,as it come from same field. i.e. all the debit value will in one column while credit value at another.<br>Then i also need to set the subTotal for each debit qty and credit qty for the item no.<br><br>Anybody know how to do this ?<br><br>Thanks<br>MavQ<br><br>

 

[MalcolmW]

click on {QTY}<br>Insert¦Running total<br>do a sum, evaluate based on a formula <br>{QTY} &gt; 0<br>reset on change of item no if you want a subtotal<br>or<br>don't reset if you want a report total<br><br>to get the second formuala, do another running total but change the &gt; to &lt; <p>Malcolm Wynden<br><a href=mailto:wynden@island.dot.net>wynden@island.dot.net</a><br><a href= > </a><br>