© Mark Conway Munro 2017

Mark Conway Munro, Learn FileMaker Pro 16, https://doi.org/10.1007/978-1-4842-2863-0_16

16. Number Functions

Mark Conway Munro1 

(1)Lewisburg, Pennsylvania, USA

Number functions are used to manipulate numbers.

Number Function Reference

FileMaker provides the following built-in number functions :

  • Abs

  • Ceiling

  • Combination

  • Div

  • Exp

  • Factorial

  • Floor

  • Int

  • Lg

  • Ln

  • Log

  • Mod

  • Random

  • Round

  • SetPrecision

  • Sign

  • Sqrt

  • Truncate

Abs

The Abs function calculates the absolute value of a number, which is a non-negative value representing its distance from zero.

Format

Abs ( number )

Parameters

number = any number.

Result

A number representing the absolute value of the number provided.

These examples show the function operating ...

Get Learn FileMaker Pro 16: The Comprehensive Guide to Building Custom Databases now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial