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

FileMaker Pro 9: The Missing Manual

by Geoff Coffey, Susan Prosser
August 2007
Beginner to intermediate content levelBeginner to intermediate
799 pages
28h 12m
English
O'Reilly Media, Inc.
Content preview from FileMaker Pro 9: The Missing Manual

Number Crunching Calculations

Although they don’t come first in the function list, number functions are the most obvious application of calculations. Since most people easily understand them, number functions are a logical place to start. A lot of the concepts you’ll learn for number functions apply to other functions as well.

Number Operators

Operators, along with fields, constants, and functions, are one of the basic building blocks of a calculation. FileMaker has five operators that specifically apply to numerical calculations, the same five that you probably already know:

  • + is for addition

  • − is for subtraction

  • * is for multiplication

  • / is for division

  • ^ is for exponentiation (“to the power of”)

“Text constants” explains how to use these operators in detail. In your day-to-day work with FileMaker, you usually use these operators to calculate the numerical values in your fields.

Note

If you’re new to calculations, you’ll want to get a handle on the material in this chapter before proceeding. But if you’ve worked with logical tests before, you can skip straight to Chapter 11.

Say you’re an event planner and you always plan for 10 percent above the expected number of attendees. Use this calculation to find your fudge factor:

	Confirmed Attendees * 1.1

Number Function Types

FileMaker also gives you dozens of functions that do special things to numbers. Because there are so many number functions, the function list breaks them up into smaller groups. The groups have descriptive names, so you can ...

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 10: The Missing Manual

FileMaker Pro 10: The Missing Manual

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

FileMaker Pro 13: The Missing Manual

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

FileMaker Pro 11: The Missing Manual

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

FileMaker Pro 14: The Missing Manual

Stuart Gripman, Susan Prosser

Publisher Resources

ISBN: 9780596514136Supplemental ContentErrata Page