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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.