Jump to content

Average value calculation not working


Recommended Posts

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 post
Share on other sites

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 post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.