From the course: FileMaker Pro Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Logic functions: The Case function

Logic functions: The Case function - FileMaker Pro Tutorial

From the course: FileMaker Pro Essential Training

Start my 1-month free trial

Logic functions: The Case function

“

- [Instructor] Introducing conditions into your formulas can help reduce the amount of calculations that you need to create and it can also make those formulas a lot more powerful as a result. For example, in this file, we've got a commission field and we're using the if function to introduce a condition. In this case, we have a test where we say if the InvoiceSubtotal is greater than 1,000, if that happens to be true, then do this which is multiply that by .05, giving us our commission total. Or if it's false, show 0.00 because in fact, there would be no commission in that case. Pretty powerful and this illuminates the need for us to have a commission formula that's greater than 1,000 and another formula that's less than 1,000. We do it all in one function. Now, let's say that things get a little bit more complicated though. Our formula now has different tiers. Instead of it just being if it's greater than 1,000,…

Contents