Average value calculation not working

[john9210 0]

I’m trying to get the average value of a field on a found set. But it’s not working.
Cost is a number field and I use the following script steps to get the average value.
Perform Find
$$Avg=Average ( BGL::Cost )

But the resulting value is incorrect. Am I missing something. I assume Average works on the found set.

[comment 1,743]

To get the average of a found set, define a summary field. The Average() function works over a related set (or a repeating field, or a list of fields).

 

[john9210 0]

Thanks. That did the trick.