15. Advanced Calculation Techniques

Logical Functions

Chapter 8, “Getting Started with Calculations,” presented an introduction to FileMaker Pro calculation formulas. This chapter deals not only with more specialized functions than the ones presented in Chapter 8, but also deals with the more programmatic functions—those that allow you to control operations of calculations. These are often called logical functions.

Chapter 8 discussed two of them: the If and Case conditional functions. This section continues with other logical functions.

The Let Function

The Let function enables you to simplify complex calculations by declaring variables to represent subexpressions. (In programming lingo, they are very much like subroutines.) These variables ...

Get FileMaker® 12 In Depth now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.