Calculate avg not numeric exp.

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Calculate avg not numeric exp.

Message

30/10/2002 15:55:36

Jose Marcenaro
Tercer Planeta
Buenos Aires, Argentine

30/10/2002 15:48:16

Michel Poiré
Ccpedq
Lévis, Québec, Canada

Information générale

Forum:

Visual FoxPro

Catégorie:

Codage, syntaxe et commandes

Titre:

Re: Calculate avg not numeric exp.

Divers

Thread ID:

00717103

Message ID:

00717112

Vues:

>fail -> CALCULATE avg(IIF(diri_taux = 0,.null.,diri_taux)) TO ni1
>
>Any idea why fox is doing that.
>

Yes. It happens when all records evaluate to .null. (all records have 0, in this case), average does not make sense..

Regards,

------------------
Jose Marcenaro
Tercer Planeta - Argentina
http://www.tercerplaneta.com

Répondre

Fil

Voir

Click here to load this message in the networking platform