Average from another File

[Heathbo]

I have a Filemaker file titled DataFiles. In it there is a number field titled Ap0. I have another field that is a summary(average) of all the Ap0 in all the records. I have another field titled round that rounds that summary field up. In another Filemaker file I have a number field titled averages. I am trying to pull the number from the round field in DataFiles. I have a relationship linking averages(DataFiles) to round. But nothing comes up in the field. I tried round as a text, number, calculation. Nothing seems to come up. Any ideas what I'm doing wrong?

[RalphL]

I assume that the calculation for Round is something like this: Ceiling ( GetSummary ( Summary ; Summary ) ) Where Summary is the summary field with the average. Round should be a number field.

This should be available in a related file if you have a valid relationship.

[transpower]

Link DataFiles to your other file by an indexed field. Then you can place the Rounded field directly on the layout in the other file.

[Heathbo]

How do you index a summary field?

[-Queue-]

You can't.

Summary fields are usually only good in the table which they summarize, since they are based on the found set and how it is sorted. To use the info in a related table/file, Sum(relationship::numfield), or Sum(relationship::numfield) / Count(relationship::serial) for an average, is the usual solution.