Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Var calculation average problem
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
01685179
Message ID:
01685181
Views:
58
Thank you very nuch, I'll try it right now

Best regards

Thomas

>Hi there,
>
>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?
>
>Thanks in advance
>
>Thomas

SUM(FIeld) / SUM(IIF(Field = 0, 0, 1))
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform