Averages aren't averaging.

[Heathbo]

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

[Lynn Johnson]

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

[transpower]

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

[Heathbo]

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.

[-Queue-]

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.

[Heathbo]

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

[Heathbo]

Never mind, I figured it out.

[hayesk]

Never mind, I figured it out.

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