Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

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

Recommended Posts

Posted

Hello all,

I'm trying to figure out whether to make field a Summary field or a Calculation that does the same things (Count; Sum, etc)

They seem to have to same options and serve the same purpose.

I am wondering if I am missing something that might adversely affect my data....

Any insight be greatly appreciated.

Posted

In general: summary fields work with the found set and are dependent on layout parts (subsummary, leading/trailing grand summary) and sort order in the case of subsummary parts. They are mostly used for reporting. Aggregate calculations (Count, Sum, etc.) are typically used with related records. They don't work with the found set. What exactly are you wanting to do?

Posted

Fitch,

Thank you. That clarifies the subtleties of the two. Right now, I am trying to calculate subtotals of Invoices, Estimates, etc, and wasn't sure which route would be best (that is if there is a difference, which there is!).

I think I will need to use summaryfields to make sure my subsummary parts show up.

Thanks, I will keep you notes in mind every time I need to make a decision.

This topic is 4567 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
×
×
  • Create New...

Important Information

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