From the course: FileMaker Pro Essential Training (2019)
Unlock the full course today
Join today to access over 23,000 courses taught by industry experts.
Number functions - FileMaker Pro Tutorial
From the course: FileMaker Pro Essential Training (2019)
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 are 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 and 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…
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.
Contents
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
(Locked)
What are calculations?3m
-
(Locked)
Touring the Calculation Dialog window4m 35s
-
(Locked)
Number functions3m 55s
-
(Locked)
Date and time functions4m 37s
-
(Locked)
Analytic text functions2m 59s
-
(Locked)
Text manipulation and functions4m 48s
-
(Locked)
Logic functions: The If function3m 26s
-
(Locked)
Logic functions: The Case function4m 10s
-
(Locked)
-
-
-