2 Replies Latest reply: Apr 7, 2011 10:18 AM by Peter Rieper RSS

    Do not load zero values

    Gerhard Laubscher

      Hi,

      I have loaded a full account extract into QV. Four of the fields that I want to use in a transactional sheet are

      1. Number of Purchases for the cycle
      2. Value of Purchases for the cycle
      3. Number of Paymentsfor the cycle
      4. Value of Paymentsfor the cycle

      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?