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

Number functions - FileMaker Pro Tutorial

From the course: Learning FileMaker 17

Start my 1-month free trial

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…

Contents