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.

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).

 

Thanks. That did the trick.