Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calculate avg not numeric exp.
Message
 
To
30/10/2002 15:48:16
Michel Poiré
Ccpedq
Lévis, Quebec, Canada
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Calculate avg not numeric exp.
Miscellaneous
Thread ID:
00717103
Message ID:
00717112
Views:
18
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform