Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Blank fields change average values
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Blank fields change average values
Miscellaneous
Thread ID:
00435828
Message ID:
00435828
Views:
47
Hi all

I've noticed that when generating reports, VFP takes a blank field as a zero - which effects the average of the values at the end of a report I'm generating. Does anyone know a simple way to get around this - I've been exporting the tables to Excel, which simply ignores the blank fields (for the purposes of averaging)...but I'm quickly getting sick of doig it this way.

Thanks in advance...


Chris Kable
FuelTrac
Next
Reply
Map
View

Click here to load this message in the networking platform