Jump to content

Good explanation of how aggregate functions work?


HPage
 Share

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

Recommended Posts

Hi, I am having trouble understanding aggregate functions.

In Filemaker The Missing Manual it states: "If you rever an aggregate function to even one related fiel, Filemaker aggregates that field's values from EVERY related record."

But say I use Count(LearnerID) in a calculation, it only counts the current active record. Not ALL records. How do I do that?

Link to comment
Share on other sites

There's no COUNTIF() function in Filemaker, so any conditions you have, you need to set them up in the related table - either as a calculation field with a numeric result, or as a numeric field to begin with (see here).

Alternatively, you could include ActiveStatus in the definition of the relationship - so that only active records are considered related. With a global gShowStatus field on the parent side, you can switch the relationship to include active-only/non-active/both as needed.

Link to comment
Share on other sites

This topic is 5785 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.