I have a field that is a calculation with

Average (Life)

on it. The field "Life" is a field in 312 records with numbers from 4 to 32 in it. There maybe some records that don't have a number in the field. Because of that I have the "Do not evaluate if all referenced fields are empty" checked. It is also a global. My problem is its blank. No value shows up at all. Any thoughts?

Heathbo

The average calculates only on the record that the argument refers to. The summary Average function calculates the average of the filled fields. e.g., four fields with value 4 and one empty field produces a summary average of 4. If you want the average to be (4+4+4+4+0)/5= 3.2, then use two fields. A summary field Sum can add all of the values in the Life fields. Then calculate the average by dividing the Sum by Get(TotalRecord Count). The result is not a global but the value is the same in every record, which is essentially the same thing.

Lynn

Don't use a global field. Use a summary field.

Don't use a global field. Use a summary field.

problem is when I use summary fields I get fields with question marks. The life field wich its summarizing is a number field thats indexed so that shouldn't cause any issues. I only want the average of the records with values in the field. Those without any number in the field I want excluded from the average. Global fields seem to be the only way info will show up in the fields.

A normal summary field based on Average should work. If you click in the field, do you see a number? The question mark may signify that the field isn't wide enough to display the data. If so, try formatting the field to use fewer decimal points or none at all.

I made the field much wider and I still get the question mark.

Never mind, I figured it out.

Never mind, I figured it out.

Could you post what it was here? In case someone else has the same problem.