Do not load zero values

[gerhardl]

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?

[#2]

Hi,

can you not just use an if statement in your expression to say only count if the field value is <> 0?

[prieper]

COUNT(IF(Value <> 0, Customer))

++
Peter