From the course: Learning FileMaker 17
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Number functions - FileMaker Pro Tutorial
From the course: Learning FileMaker 17
Number functions
- [Instructor] In this movie, I'm going to introduce you to the most useful and common functions that FileMaker offers for manipulating numeric data. The number functions are used to manipulate and perform functions with numeric data and as a class they're relatively easy to learn because most of them only have one or two parameters. So say for example, we want to create a sales tax calculation, I'm going to go into manage database. I'm going to go to the sales tax field and change it from number to a calculation. I'll hit change, confirm with FileMaker that that's what I intend to do and I'll create a simple formula where I just say invoice subtotal multiplied by sales tax rate. Now there's nothing really earth shattering going on there except what I would suggest to do is to use your tools. So for example, under tools, I like using Data Viewer. I hit the plus sign here but in this case what I would do is I would come up with the formula and as I'm typing it, FileMaker is giving me…
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.