Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Var calculation average problem
Message
 
To
31/10/2022 15:00:30
John Ryan
Captain-Cooker Appreciation Society
Taumata Whakatangi ..., New Zealand
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
01685179
Message ID:
01685184
Views:
43
Thank you, I'll try it.

Best regards

Thomas

>>I am trying to figure out how to create a report var calculation an average value but avoiding records where the value of the field is o. How can I do this?

AVERAGE FOR allows you to filter records by an expression, so try something like
AVERAGE myfield to myvar for myfield <>0
Previous
Reply
Map
View

Click here to load this message in the networking platform