This content has been marked as final. Show 2 replies
I have loaded a full account extract into QV. Four of the fields that I want to use in a transactional sheet are
I then add them in list boxes, with a purchase summary box, payments summary box.
My problem is that when someone did not make a purchase/payment it is displayed as R0.00, but the summary box obviously still counts it (in total count), so for both purchases and payments it now shows the total amount of customers on our books, as opposed to the total amount of purchases and payments.
What should I do if I want the total count to not include zeroes?