Jump to content

Calculation of a field within a found set


This topic is 7335 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Two ways to accomplish this.

You can use Summary fields. They operate on the current set of records, be that the found set while in browse mode, or a sub-summary set while in preview mode.

You can also use the normal calculation aggregate functions on a related set of records.

If you found set is based on a really complicated find, then the summary field will probably serve you best, although you may need to use some GetSummary() functions to get exactly the summarizations that you want.

If you find is simple, such as counting and totalling the invoices for a client, then the aggregate functions through a relationship is a better way to go.

Link to comment
Share on other sites

This topic is 7335 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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