Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Counting
Message
 
To
13/01/1999 18:09:56
Ian Matthews
Up & Running Technologies Inc
Chestermere, Alberta, Canada
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Miscellaneous
Thread ID:
00175717
Message ID:
00175718
Views:
21
>I want a counter to increment everytime a condition is true.
>
>I have a report with DATA GROUPING. Each line has an AVAILABLE field with a numeric value of 1, 2, or 3. I want a counter to increment each time AVAILABLE=1.
>
>I thought the solution was to add to my VARIABLES list an item (I named) RESPONDED and to have it COUNT, with a VALUE TO STORE of AVAILABLE=1. Apparently not! This simply increments for each entry rather than just the ones that have AVAILABLE=1. I understand why it is doing what it is doing but I don't know how to do what I want to do. Do you???
>
>Idea's???

Change it from COUNT to SUM. VALUE TO STORE should be IIF(AVAILABLE=1, 1, 0).
Rich Addison, Micro Vane, Inc., Kalamazoo, MI
Relax, don't worry, have a homebrew.
- Charlie Papazian, The New Complete Joy of Home Brewing
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform