From the course: Learning FileMaker 16
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Logic functions - FileMaker Pro Tutorial
From the course: Learning FileMaker 16
Logic functions
- [Instructor] The logical function group contains some of the most interesting and powerful functions available in Filemaker Pro. And I'm going to focus on two of them, in particular. These two happen to be functions that I use in probably half of the calculation formulas that I write. So let's dive right in to taking a look at how these functions work. So what we're going to do in this example is create a field that's called commission. This is going to be the salesperson's commission on each invoice sale. So we're going to calculate this value based on a percentage of the overall total. So let's create a commission field, make it a calculation, and hit create. So let's say when we were first building this, the rule about commission was that the salesperson gets 5% commission on each sale. So let's look at invoice total. And we'll go to our mathematical operator. Invoice total times 0.05, so it's a 5% commission. Our result is a number, we hit okay. So now, we can put that field on…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.