Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Averaging averages, disregarding Zero Values
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00450159
Message ID:
00450161
Views:
22
>In a report I'm working on, I need to calculate a summary of the average days to close. Some detail lines have a Zero AVGDAYS, and I don't want those included in my overall average... How to do this?
>
>Grace and peace,
>John

SELECT * from YourTable 
   WHERE avgdays > 0
   INTO CURSOR allavgdays

And then run the report off of that.
HTH,
George
Everything we see or seems
Is but a dream within a dream
- Edgar Allen Poe
Previous
Reply
Map
View

Click here to load this message in the networking platform