Category: Number
Syntax: Factorial (number {; numberOfFactors }) |
Parameters:
numberAny expression that resolves to a positive integer.
numberOfFactorsAny expression that resolves to a positive integer that represents how many factors to include in the multiplication.
Parameters in curly braces { } are optional.
Data type returned: Number
Description:
Returns the factorial of number, stopping either at 1 or stopping at the optional numberOfFactors. The factorial of a number n is defined as nx(n1)x(n2)x(n3)...x1. Factorials are useful in statistics and combinatorics. In mathematics, factorials are usually represented by an exclamation mark. 4! = Factorial (4) = 4x3x2x1 = 24.
One application of factorials is to determine how many unique ways a set of objects can be ordered. For instance, a set of three objects {A, B, C} can be ordered 3! = 6 ways: {ABC, ACB, BAC, BCA, CAB, CBA}.
Examples:
Function |
Results |
---|---|
Factorial ( 3 ) |
Returns 6, which = 3x2x1. |
Factorial ( 10; 3 ) |
Returns 720, which = 10x9x8. |
: FileMaker Specifications
FileMaker 8 Product Line
Specifications and Storage Limits
Field Types and Import/Export Formats
: Calculation Functions
Working with Calculations Primer
Calculation Signatures
Calculation Functions
: Custom Functions
Custom Functions Primer
Useful Custom Functions
: Script Steps
Scripting Primer
Script Step Reference
: Quick Reference
FileMaker Error Codes
FileMaker Keyboard Shortcuts
FileMaker Network Ports
FileMaker Server Command Line Reference
FileMaker XML Reference
: Other Resources
Where to Go for More Information