Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Averaging averages, disregarding Zero Values
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00450159
Message ID:
00450161
Vues:
23
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform