john9210 Posted May 26, 2020 Share Posted May 26, 2020 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. Link to comment Share on other sites More sharing options...
comment Posted May 26, 2020 Share Posted May 26, 2020 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). Link to comment Share on other sites More sharing options...
john9210 Posted May 26, 2020 Author Share Posted May 26, 2020 Thanks. That did the trick. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 1445 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now