Aggregate Functions
Aggregate functions apply to a group of fields in related records or repeating fields.
|
Syntax |
Data Type Returned |
|---|---|
|
Average ( field {; field...} ) |
Number |
|
Count ( field {; field...} ) |
Number |
|
Max ( field {; field...} ) |
Text, Number, Date, Time, Timestamp |
|
Min ( field {; field...} ) |
Text, Number, Date, Time, Timestamp |
|
StDev ( field {; field...} ) |
Number |
|
StDevP ( field {; field...} ) |
Number |
|
Sum ( field {; field...} ) |
Number |
|
Variance ( field {; field...} ) |
Number |
|
VarianceP ( field {; field...} ) |
Number |
: 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 Signatures
- Aggregate Functions
- Date Functions
- Design Functions
- External Functions
- Financial Functions
- Get Functions
- Logical Functions
- Number Functions
- Repeating Functions
- Summary Functions
- Text Functions
- Text Formatting Functions
- Time Functions
- Timestamp Functions
- Trigonometric Functions
Calculation Functions
- Abs()
- Atan()
- Average()
- Case()
- Ceiling()
- Choose()
- Combination()
- Cos()
- Count()
- DatabaseNames
- Date()
- Day()
- DayName()
- DayNameJ()
- DayOfWeek()
- DayOfYear()
- Degrees()
- Div()
- Evaluate()
- EvaluationError()
- Exact()
- Exp()
- Extend()
- External()
- Factorial()
- FieldBounds()
- FieldComment()
- FieldIDs()
- FieldNames()
- FieldRepetitions()
- FieldStyle()
- FieldType()
- Filter()
- FilterValues()
- Floor()
- FV()
- Get(AccountName)
- Get(ActiveFieldContents)
- Get(ActiveFieldName)
- Get(ActiveFieldTableName)
- Get(ActiveModifierKeys)
- Get(ActiveRepetitionNumber)
- Get(ActiveSelectionSize)
- Get(ActiveSelectionStart)
- Get(AllowAbortState)
- Get(AllowToolbarState)
- Get(ApplicationLanguage)
- Get(ApplicationVersion)
- Get(CalculationRepetitionNumber)
- Get(CurrentDate)
- Get(CurrentHostTimestamp)
- Get(CurrentTime)
- Get(CurrentTimestamp)
- Get(CustomMenuSetName)
- Get(DesktopPath)
- Get(DocumentsPath)
- Get(ErrorCaptureState)
- Get(ExtendedPrivileges)
- Get(FileMakerPath)
- Get(FileName)
- Get(FilePath)
- Get(FileSize)
- Get(FoundCount)
- Get(HighContrastColor)
- Get(HighContrastState)
- Get(HostIPAddress)
- Get(HostName)
- Get(LastError)
- Get(LastMessageChoice)
- Get(LastODBCError)
- Get(LayoutAccess)
- Get(LayoutCount)
- Get(LayoutName)
- Get(LayoutNumber)
- Get(LayoutTableName)
- Get(LayoutViewState)
- Get(MultiUserState)
- Get(NetworkProtocol)
- Get(PageNumber)
- Get(PortalRowNumber)
- Get(PreferencesPath)
- Get(PrinterName)
- Get(PrivilegeSetName)
- Get(RecordAccess)
- Get(RecordID)
- Get(RecordModificationCount)
- Get(RecordNumber)
- Get(RecordOpenCount)
- Get(RecordOpenState)
- Get(RequestCount)
- Get(RequestOmitState)
- Get(ScreenDepth)
- Get(ScreenHeight)
- Get(ScreenWidth)
- Get(ScriptName)
- Get(ScriptParameter)
- Get(ScriptResult)
- Get(SortState)
- Get(StatusAreaState)
- Get(SystemDrive)
- Get(SystemIPAddress)
- Get(SystemLanguage)
- Get(SystemNICAddress)
- Get(SystemPlatform)
- Get(SystemVersion)
- Get(TextRulerVisible)
- Get(TotalRecordCount)
- Get(UserCount)
- Get(UserName)
- Get(UseSystemFormatsState)
- Get(WindowContentHeight)
- Get(WindowContentWidth)
- Get(WindowDesktopHeight)
- Get(WindowDesktopWidth)
- Get(WindowHeight)
- Get(WindowLeft)
- Get(WindowMode)
- Get(WindowName)
- Get(WindowTop)
- Get(WindowVisible)
- Get(WindowWidth)
- Get(WindowZoomLevel)
- GetAsBoolean()
- GetAsCSS()
- GetAsDate()
- GetAsNumber()
- GetAsSVG()
- GetAsText()
- GetAsTime()
- GetAsTimestamp()
- GetField()
- GetNextSerialValue()
- GetNthRecord()
- GetRepetition()
- GetSummary()
- GetValue()
- Hiragana()
- Hour()
- If()
- Int()
- IsEmpty()
- IsValid()
- IsValidExpression()
- KanaHankaku()
- KanaZenkaku()
- KanjiNumeral()
- Katakana()
- Last()
- LayoutIDs()
- LayoutNames()
- Left()
- LeftValues()
- LeftWords()
- Length()
- Let()
- Lg()
- Ln()
- Log()
- Lookup()
- LookupNext()
- Lower()
- Max()
- Middle()
- MiddleValues()
- MiddleWords()
- Min()
- Minute()
- Mod()
- Month()
- MonthName()
- MonthNameJ()
- NPV()
- NumToJText()
- PatternCount()
- Pi
- PMT()
- Position()
- Proper()
- PV()
- Quote()
- Radians()
- Random
- RelationInfo()
- Replace()
- RGB()
- Right()
- RightValues()
- RightWords()
- RomanHankaku()
- RomanZenkaku()
- Round()
- ScriptIDs()
- ScriptNames()
- Seconds()
- SerialIncrement()
- SetPrecision()
- Sign()
- Sin()
- Sqrt()
- StDev()
- StDevP()
- Substitute()
- Sum()
- TableIDs()
- TableNames()
- Tan()
- TextColor()
- TextColorRemove()
- TextFont()
- TextFontRemove()
- TextFormatRemove()
- TextSize()
- TextSizeRemove()
- TextStyleAdd()
- TextStyleRemove()
- Time()
- Timestamp()
- Trim()
- TrimAll()
- Truncate()
- Upper()
- ValueCount()
- ValueListIDs()
- ValueListItems()
- ValueListNames()
- Variance()
- VarianceP()
- WeekOfYear()
- WeekOfYearFiscal()
- WindowNames
- WordCount()
- Year()
- YearName()
: Custom Functions
Custom Functions Primer
Useful Custom Functions
- Useful Custom Functions
- Number Calculations
- Date Calculations
- Text and Data Conversions
- Email Tools
- Developer Tools
- System Constants
- Toolkit for Complex Data Structures
: 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
- FileMaker XML Reference
- About FileMaker and XML
- URL Syntax for Web Access to FileMaker Data
- FileMaker XML Grammars
- Query Parameters for XML/XSLT URL Requests
- FileMaker XML and XSLT Namespaces
: Other Resources
Where to Go for More Information
- Where to Go for More Information
- FileMaker
- General Information on Relational Databases
- Data Modeling and Database Design
- Project Management, Programming, and Software Development
- Running a FileMaker Consulting Practice
- General Resources for Tips and Tricks
- Hosting FileMaker Databases on the Web
- FileMaker News Sources
- Developer Tools
- Web Programming
- PHP
- ODBC/JDBC
FileMaker 8 Functions and Scripts Desk Reference
ISBN: 0789735113
EAN: 2147483647
EAN: 2147483647
Year: 2004
Pages: 352
Pages: 352
