I have a database with 3 fields. The first is a date field. Fields B and C are numeric. I enter a value in field B every day. I enter a value in field C every 6 days. When I Group Up by month, for example, and then average the summary records, field B is OK; but field C is about 1/6th the correct value. How can I average only the records which are not empty?
There is an easy way to do this in the Summary Workshop. First, use the Find/Select dialog to set up a favorite search for non-empty values in the field. In your case, the search would be C Is Not Empty. Be sure to save that as a favorite search.
Then, in the Summary Workshop, use the Data popup to set the data source to the favorite search you set up. Now the average will include only the non-empty values.
Would that not eliminate 5 out of six values from field A? I would like to compare the monthly average of 30 or so values in field A to the monthly average of 5 or so values in field B.