Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
COUNT / Disregarding 0 values
Message
From
16/07/2003 12:37:10
John Vlahos
V I Software Solutions Design
Mississauga, Ontario, Canada
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
COUNT / Disregarding 0 values
Miscellaneous
Thread ID:
00810725
Message ID:
00810725
Views:
55
How can I using the report designed of VFP 7.0 disregards all detail lines in a COUNT of a value, if the value is not entered or is 0.

For example if in my detail of a report my lines are as follows:

Inv. No. Amount.
-------------------
1 100.00
2 200.00
3 0.00

A regular count of amount would result in 3, however I need it to exclude the 0.00 amount and display 2 as the result.
Next
Reply
Map
View

Click here to load this message in the networking platform