Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Counting
Message
From
13/01/1999 18:27:27
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:
00175720
Views:
27
>>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).

Thanx... I knew I had done this before but could not find it anywhere. My excuse is I have the flu and feel terrible.

Thanx again!
Previous
Reply
Map
View

Click here to load this message in the networking platform