Skip to Main Content
FileMaker Pro 14: The Missing Manual
book

FileMaker Pro 14: The Missing Manual

by Stuart Gripman, Susan Prosser
May 2015
Beginner to intermediate content levelBeginner to intermediate
970 pages
32h 12m
English
O'Reilly Media, Inc.
Content preview from FileMaker Pro 14: The Missing Manual

Chapter 10. Understanding Calculations

When you learned about tables, fields, and relationships in the previous chapters, you dabbled in FileMaker’s calculation dialog box. Most people first encounter the Specify Calculation window when they’re creating a calculation field, so it’s easy to think that’s the only place it’s used. True, writing formulas for calculation fields is probably the most common use of FileMaker’s calculation engine (that’s the fancy name for the code that handles math for your database), but that’s far from the only use, as you’ll see in this chapter.

No matter where you run into the Specify Calculation window, it works the same way. You use that window’s field list, operators, and predefined functions to tell the calculation how to find the value you need. This chapter tells you how the basic concept works.

While calculations can make your database total invoices, analyze trends, and calculate dates and times, they aren’t limited to number-crunching tasks. You can use them to find out about the computer your database is running on, track who’s logged into the system, monitor their privileges, and then perform logical tests based on what you find. You’ll start by learning how FileMaker handles calculations, and then you’ll see how some common functions can take your database up to a new level of power.

Understanding Calculations

Way back on Creating a Simple Calculation, you saw how to create a field that’s defined as a calculation. A calculation is a mathematical ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

FileMaker Pro 11: The Missing Manual

FileMaker Pro 11: The Missing Manual

Stuart Gripman, Susan Prosser
FileMaker Pro 12: The Missing Manual

FileMaker Pro 12: The Missing Manual

Susan Prosser, Stuart Gripman
FileMaker Pro 10: The Missing Manual

FileMaker Pro 10: The Missing Manual

Susan Prosser, Geoff Coffey
FileMaker Pro 9: The Missing Manual

FileMaker Pro 9: The Missing Manual

Geoff Coffey, Susan Prosser

Publisher Resources

ISBN: 9781491917473Supplemental ContentErrata Page