Difference between revisions of "Formula Functions"
imported>Aeric |
imported>Aeric |
||
| Line 172: | Line 172: | ||
[[VALUE]]<br> | [[VALUE]]<br> | ||
|} | |} | ||
== Aggregate Functions == | == Aggregate Functions == | ||
The [[Aggregate Functions]] are not available in every context, because of their potential impact on performance. They let you select a collection of records in an arbitrary object and perform a summary calculation on those records. | |||
(For most purposes, a [[Rollup Summary Field]] tends to be more useful, as it lets you define a summary calculation for a set of ''related'' records--for example, to sum the line items in an order.) | |||
{| border="0" cellpadding="5" cellspacing="0" width="50%" | {| border="0" cellpadding="5" cellspacing="0" width="50%" | ||
|-valign="top" | |-valign="top" | ||
| Line 180: | Line 184: | ||
| [[Aggregate Functions#COUNT|COUNT]] | | [[Aggregate Functions#COUNT|COUNT]] | ||
|} | |} | ||
==Miscellaneous Functions== | ==Miscellaneous Functions== | ||
Revision as of 01:55, 13 May 2014
About the Formula Functions
Formula functions are logical and programmatic functions, used with fields and operators to build Formula Expressions in any of the following platform elements:
- Computed Fields in Reports
- Custom Access Criteria
- Default Field Values
- Formula Fields
- Layout Rules
- Macros#Visibility Criteria
- Rules#Execution Criteria
- Rule Actions to add or update a record
- Validation Criteria
Conventions
The following conventions are used in these functions:
Element Description 'string' Strings must be enclosed with single quotes 'dString' Date strings must be enclosed with single quotes int An integer,for example, a number representing the number of days (or months or years) value An argument in date- and date/time-related Formula Functions, which defines a unit of time [ ,optional] Optional values are shown in brackets, as [ ,option1, option2]
Date Functions
See Date for details about these Day, Date and Time-related formula functions:
Logical Functions
See Logical for details about functions resulting in TRUE/FALSE (YES/NO, 1/0):
Math Functions
See Math for details about mathematical functions:
Text Functions
See Text for details about text-related formula functions:
Aggregate Functions
The Aggregate Functions are not available in every context, because of their potential impact on performance. They let you select a collection of records in an arbitrary object and perform a summary calculation on those records.
(For most purposes, a Rollup Summary Field tends to be more useful, as it lets you define a summary calculation for a set of related records--for example, to sum the line items in an order.)
| MAXIMUM MINIMUM |
SUM AVG |
COUNT |