As the name implies, aggregate functions in FileMaker Pro Calculations are used…for calculating various summarizations of sets of data.…So for example we can look at what our options are if we go…into Manage>Database.…Say for example that we want to change the Total Invoices Paid from a Number…field that requires us to enter data into it, into a Calculation field that…will dynamically update this information.…So let's do that, let's change our Calculation and hit Change, say OK.…This allows us to look over here in the upper right-hand corner at the…Aggregate Function options.…
You'll notice that we can average a set of Data, Count a set of data;…we've already seen List, a Return to Limited List of data, in some of the other…exercises in this course.…Max or Minimums, and a very common one is Sum, and some of the other ones that…are not quite as common, but also available to you if you need it.…Now when you choose one of these functions, you'll see that it has at least one…parameter that's required and that's a field. What these brackets mean…
Author
Released
3/19/2013- Managing access to your database
- Parsing text with calculation functions
- Using calculations in field validation and auto enter options
- Creating nested subsummary and crosstab reports
- Creating user-driven and multi-criteria relationships
- Working with intermediate script techniques
- Extending Web Viewer using HTML5 and data URLs
- Sharing databases on a network using FileMaker Server
- Publishing your databases to the web using the Instant Web Publishing or PHP
Skill Level Advanced
Duration
Views
Related Courses
-
FileMaker Pro 12 Essential Training
with Cris Ippolite10h 28m Beginner -
Learning FileMaker Go
with Cris Ippolite1h 15m Intermediate
-
Introduction
-
Welcome46s
-
-
1. Managing Access to Your Database
-
Creating accounts6m 25s
-
Customizing privilege sets9m 30s
-
Applying extended privileges4m 45s
-
-
2. Calculations: Extending Text Functions
-
Parsing lists of values9m 55s
-
3. Calculations: Logical Functions
-
4. Other Uses of the Calculation Dialog
-
5. Calculations: Working with Aggregate Functions
-
6. Advanced Reporting Options
-
Reviewing subsummary reports6m 10s
-
Creating a crosstab report14m 32s
-
-
7. Extending FileMaker Relationships
-
8. Scripting for Developers
-
The Set Field script step5m 28s
-
Working with script variables10m 31s
-
Setting script parameters3m 12s
-
9. Extending Web Viewer
-
Using HTML5 in the Web Viewer10m 27s
-
10. Sharing Your Databases on the Network
-
Best practices5m 37s
-
Configuring FileMaker Server13m 52s
-
Scheduling backups7m 23s
-
11. Web Publishing: PHP and Instant Web Publishing
-
Preparing your files for IWP6m 24s
-
Touring the IWP interface6m 51s
-
Design considerations in IWP8m 48s
-
Scripting in IWP8m 37s
-
Setting up your file for PHP6m 25s
-
Conclusion
-
Goodbye54s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Working with calculation functions and related fields